﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text; 
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient; 
namespace INTEX.DataBase.Tools
{
    public partial class INTEXDBC
    {
        #region======A==============
        #endregion

        #region======B==============
        public void InsertBSSATZ(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO BSSATZ(BSMANDANT, BSKART, BSAENDZL, BSAENDBEN, BSAENDDAT, BSNEUBEN, BSNEUDAT, BSMTART, BSBEZ, BSSTDKVAR, BSSTAKZ, BSMUSTER, BSFARBVW, BSFARBSTUE, BSPFVARN, BSPROGRP, BSARTGRP, BSPMGRP, BSBAUMKZ, BSVERWEN, BSFDZ, BSFDZLEIST, BSKNOTEN, BSFAKTOR, BSSRFNR, BSCADKEY, BSANZTB, BSKRANF, BSKRENDE, BSKRMITTE, BSFDFLGKR, BSKRART, BSSCHAERBR, BSRIETF, BSFDFLGRI, BSBEM, BSZOLLTNR, BSSUBSTGR, BSHANDICAP, BSAFFINITY, BSSUBST1, BSSUBST2, BSBLEACHED, BSCLORINEST, BSFIXTEMP, BSPRODH, BSMATKL, BSPLGRP, BSPLANART, BSEKGRP, BSBSTME, BSVABME, BSEKWSL, BSINKZ, BSINPR, BSBEWAB, BSFILLER)"
                + "VALUES (:BSMANDANT, :BSKART, 0, '        ', 0, :BSNEUBEN, :BSNEUDAT, '    ', '                                        ', '1 ', 'A', 'N', 'J', 'J', ' ', '   ', '   ', '    ', :BSBAUMKZ,:BSVERWEN, 0, 0, 'J', 1000, '               ', '                              ', '00', '          ', '          ', ' ', '           ', '          ', 0, 0, '           ', '                                        ', '                    ', '   ', '   ', '               ', '  ', '  ', ' ', ' ', 0, '                  ', '         ', '  ', '                    ', '   ', '   ', ' ', '    ', ' ', 0, 0, '                                                                ')";
            or1.Parameters.Add("BSMANDANT", OracleType.NVarChar).Value = dwData["BSMANDANT"].ToString();
            or1.Parameters.Add("BSKART", OracleType.NVarChar).Value = dwData["BSKART"].ToString();
            or1.Parameters.Add("BSNEUBEN", OracleType.NVarChar).Value = dwData["BSNEUBEN"].ToString();
            or1.Parameters.Add("BSNEUDAT", OracleType.Number).Value = dwData["BSNEUDAT"].ToString();
            or1.Parameters.Add("BSBAUMKZ", OracleType.NVarChar).Value = dwData["BSBAUMKZ"].ToString();
            or1.Parameters.Add("BSVERWEN", OracleType.NVarChar).Value = dwData["BSVERWEN"].ToString();
            setResult = Connect2Proxy(or1);
        }
        public void InsertBHSATZ(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO BHSATZ(BHMANDANT, BHKART, BHKVAR, BHAENDZL, BHAENDBEN, BHAENDDAT, BHNEUBEN, BHNEUDAT, BHFERTKZ, BHLIEFNR, BHFILLER1, BHLAN, BHKUNDNR, BHHERART, BHSTATUS, BHSTAKZ, BHGASTUE, BHBASTUE, BHAUFTR, BHKGNET, BHLGG, BHRSP, BHSCHLIGR1, BHSCHLIGR2, BHSCHLIGR3, BHSCHLIGR4, BHSCHLIGR5, BHSCHLIGR6, BHSCHLIGR7, BHSCHLIGR8, BHSCHLIGR9, BHSCHLIGR10, BHSCHLIGR11, BHSCHLIGR12, BHSCHLIGR13, BHSCHLIGR14, BHSCHLIGR15, BHSCHLINR1, BHSCHLINR2, BHSCHLINR3, BHSCHLINR4, BHSCHLINR5, BHSCHLINR6, BHSCHLINR7, BHSCHLINR8, BHSCHLINR9, BHSCHLINR10, BHSCHLINR11, BHSCHLINR12, BHSCHLINR13, BHSCHLINR14, BHSCHLINR15, BHCADKEY, BHBEM, BHDEKPR, BHZUGMENG, BHVRPR, BHLEPR, BHBWPR1, BHBWPR2, BHBWPR3, BHMATKTO, BHKTO1, BHEG, BHBON, BHZUSCHL11, BHZUSCHL12, BHZUSCHL13, BHZUSCHL21, BHZUSCHL22, BHZUSCHL23, BHABSABF, BHKALABF, BHAUFKZ, BHKETTLG, BHFERTZT, BHWDBSZT, BHDISPOKZ, BHDISPOZR, BHMINBST, BHMAXBST, BHBSLPKT, BHLO, BHLB, BHABCKL, BHSACHDSP, BHPROF, BHPRUEFANW, BHTAX, BHFILLER)"
                + "VALUES ("
            + ":BHMANDANT,:BHKART,:BHKVAR, 0, '        ', 0, :BHNEUBEN, :BHNEUDAT, 'E', '        ', '          ', '                    ', '        ', :BHHERART, 'K', ' ', 'V', ' ', 'N', 0, 0, 0, '1', '1', '1', '1', '1', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '112', '108', '108', '108', '108', '000', '000', '000', '000', '000', '000', '000', '000', '000', '000', '      ', '                                        ', 0, 0, 0, 0, 0, 0, 0, '      ', '      ', ' ', ' ', '        ', '        ', '        ', '        ', '        ', '        ', 10000, 200, ' ', 0, 0, 0, 'B', ' ', 2000, 30000, 0, '  ', '  ', ' ', '        ', 'V', 'J', '   ', '                                                                                                                                            ')";
            or1.Parameters.Add("BHMANDANT", OracleType.NVarChar).Value = dwData["BHMANDANT"].ToString();
            or1.Parameters.Add("BHKART", OracleType.NVarChar).Value = dwData["BHKART"].ToString();
            or1.Parameters.Add("BHKVAR", OracleType.NVarChar).Value = dwData["BHKVAR"].ToString();
            or1.Parameters.Add("BHHERART", OracleType.NVarChar).Value = dwData["BHHERART"].ToString();
            or1.Parameters.Add("BHNEUBEN", OracleType.NVarChar).Value = dwData["BHNEUBEN"].ToString();
            or1.Parameters.Add("BHNEUDAT", OracleType.Number).Value = dwData["BHNEUDAT"].ToString();
            setResult = Connect2Proxy(or1);
        }
        public void InsertBSGROE(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO BSGROE(BSGMANDANT, BSGART, BSGMTYP, BSGLFD, BSGAENDZL, BSGAENDBEN, BSGAENDDAT, BSGNEUBEN, BSGNEUDAT, BSGKETTART, BSGMAXLG, BSGMAXGW, BSGLOS, BSGANZTB, BSGLLEIST, BSGRLEIST, BSGFILLER)"
+ "VALUES (:BSGMANDANT, :BSGART, '        ', 1, 1, '        ', 0, :BSGNEUBEN, :BSGNEUDAT, '      ', 0, 0, 0, 0, '    ', '    ', '                                    ')";
            or1.Parameters.Add("BSGMANDANT", OracleType.NVarChar).Value = dwData["BSGMANDANT"].ToString();
            or1.Parameters.Add("BSGART", OracleType.NVarChar).Value = dwData["BSGART"].ToString();
            or1.Parameters.Add("BSGNEUBEN", OracleType.NVarChar).Value = dwData["BSGNEUBEN"].ToString();
            or1.Parameters.Add("BSGNEUDAT", OracleType.Number).Value = dwData["BSGNEUDAT"].ToString();
            setResult = Connect2Proxy(or1);

        }
        public void InsertBSFARB(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO BSFARB(BSFMANDANT, BSFKART, BSFKVAR, BSFKFARBE, BSFKZKETTF, BSFSTATUS, BSFSFKZ, BSFBEZ, BSFTEXTSCHL, BSFFKARTNR, BSFROHFARBE, BSFMUDESS, BSFUNIFARB, BSFZTWAHL, BSFRUESTGRP, BSFPRUEFGRP, BSFFDVF, BSFPRGRP, BSFGRPBEZ, BSFPREIS, BSFZUABPR, BSFZUABAB, BSFNFART, BSFWERT, BSFKZPA, BSFZUABVH, BSFZUABAK, BSFZUABKU, BSFZUABPROZ, BSFFA, BSFGA, BSFQA, BSFQPKTH, BSFQPKTLH, BSFLOAN, BSFLBAN, BSFLPAN, BSFABKZAN, BSFPKL, BSFVBBRT, BSFBRTTOLPL, BSFBRTTOLMI, BSFVBGRQM, BSFVBGRLFD, BSFGWTOLPL, BSFGWTOLMIN, BSFLAEAEND, BSFGWVERL, BSFRESTSCHL, BSFPHWERTMI, BSFPHWERTMA, BSFWEISSGRD, BSFNETZFVON, BSFNETZFBIS, BSFNETZFSEK, BSFRSSFTRKV, BSFRSSFTRKB, BSFUNIFAEH, BSFFADGERAD, BSFMUSTFRB, BSFVORB, BSFNACHB, BSFMU, BSFMURLOD, BSFMUPROD, BSFMUCTOD, BSFMUDTRL, BSFMUBIRL, BSFLMANRKRS, BSFLMALFDNR, BSFLMAPOS, BSFLODKRS, BSFLODLFD, BSFLODPOS, BSFFILLER, BSFAENZL, BSFAENB, BSFAEND, BSFNEUB, BSFNEUD)"
                + "VALUES ("
            + "'" + dwData["BSFMANDANT"].ToString() + "', '" + dwData["BSFKART"].ToString() + "','" + dwData["BSFKVAR"].ToString() + "','" + dwData["BSFKFARBE"].ToString() + "', ' ', 'A', ' ','" + dwData["BSFBEZ"].ToString() + "', '          ', '          ', '          ', '          ', '          ', 0, '   ', ' ', '   '"
            + ", ' ', '                    ', 0, 0, 0, '    ', 0, ' ', 0, 0, 0, ' ', 0, 0, 0, 0, 0, '  ', '  ', '        ', ' ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, ' ', ' ', '          '"
            + ", '   ', '   ', ' ', '00', '00', ' ', 0, '        ', '  ', '0000', '00', '  ', '000000', '000', '                                                              '"
            + ", 1, '        ', 0,'" + dwData["BSFNEUB"].ToString() + "'," + dwData["BSFNEUD"].ToString() + ")";
            /*
            or1.Parameters.Add("BSFMANDANT", OracleType.NVarChar).Value = dwData["BSFMANDANT"].ToString();
            or1.Parameters.Add("BSFKART", OracleType.NVarChar).Value = dwData["BSFKART"].ToString();
            or1.Parameters.Add("BSFKVAR", OracleType.NVarChar).Value = dwData["BSFKVAR"].ToString();
            //or1.Parameters.Add("BSFKFARBE", OracleType.NVarChar).Value = dwData["BSFKFARBE"].ToString();
            //or1.Parameters.Add("BSFBEZ", OracleType.NVarChar).Value = dwData["BSFBEZ"].ToString();
            or1.Parameters.Add("BSFNEUB", OracleType.NVarChar).Value = dwData["BSFNEUB"].ToString();
            or1.Parameters.Add("BSFNEUD", OracleType.Number).Value = dwData["BSFNEUD"].ToString();*/
            setResult = Connect2Proxy(or1);
        }
        public void InsertBASTGA(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;

            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO BASTGA(BAGMANDANT, BAGART, BAGVAR, BAGFARBE, BAGPOS, BAGGART, BAGGVAR, BAGGFARBE, BAGFDZ, BAGABF, BAGKGNET, BAGKGBRUT, BAGDISPOKZ, BAGBEM, BAGVARKZ, BAGAUFMSL, BAGFILLER)"
                + "VALUES (:BAGMANDANT, :BAGART, :BAGVAR, :BAGFARBE, :BAGPOS, 'J100                ', '3  ', '          ', 8308, 0, 98126, 98126, 'B', '                    ', ' ', '  ', '                  ')";
            or1.Parameters.Add("BAGMANDANT", OracleType.NVarChar).Value = dwData["BAGMANDANT"].ToString();
            or1.Parameters.Add("BAGART", OracleType.NVarChar).Value = dwData["BAGART"].ToString();
            or1.Parameters.Add("BAGVAR", OracleType.NVarChar).Value = dwData["BAGVAR"].ToString();
            or1.Parameters.Add("BAGFARBE", OracleType.NVarChar).Value = dwData["BAGFARBE"].ToString();
            or1.Parameters.Add("BAGPOS", OracleType.NVarChar).Value = dwData["BAGPOS"].ToString();
            setResult = Connect2Proxy(or1);
        }
        #endregion

        #region======C==============
        #endregion

        #region======D==============
        #endregion

        #region======E==============
        #endregion

        #region======F==============
        #endregion

        #region======G==============
        #endregion

        #region======H==============
        #endregion

        #region======K==============
        //KDSTAMM KUNDVER
        public void InsertKDSTAMM(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            or1 = OracleDB.CreateCommand();
            DataSet result = new DataSet();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    or1.CommandText = " INSERT INTO KDSTAMM(KDMANDANT, KDKUNDNR, KDKUNDNA, KDLAND, KDPLZ, KDORT, KDBZ, KDBZBEZ, KDSTAKZ, KDSTADAT, KDABCKL, KDANREDE, KDNAME1, KDKNAME, KDNAME2, KDSTRASSE1, KDSTRASSE2, KDPLZPOSTF, KDPOSTFACH, KDTEL, KDTELEX, KDFAX, KDBTX, KDDATEX, KDMBOX, KDMAILADR, KDTTEX, KDCOUNTY, KDCITY, KDZENTR, KDZENTRR, KDSPRKZ, KDBBN, KDSONDSTA, KDKDNRALT, KDLO, KDLB, KDLP, KDLIEFNR, KDINVDAT, KDDEBNR, KDKREDNR, KDUEBKZ, KDAUSK, KDAUSKKZ, KDMAHNST, KDMAHNH, KDGRPCUNO, KDCLEARCUNO, KDBIC1, KDIBAN1, KDBIC2, KDIBAN2, KDKREDLIM1, KDKREDVON1, KDKREDBIS1, KDKREDNLDAT1, KDVERS1, KDVERS21, KDKREDSB1, KDVERSTAGE1, KDVERSNR1, KDKREDLIM2, KDKREDVON2, KDKREDBIS2, KDKREDNLDAT2, KDVERS2, KDVERS22, KDKREDSB2, KDVERSTAGE2, KDVERSNR2, KDKREDLIM3, KDKREDVON3, KDKREDBIS3, KDKREDNLDAT3, KDVERS3, KDVERS23, KDKREDSB3, KDVERSTAGE3, KDVERSNR3, KDKREDLIM4, KDKREDVON4, KDKREDBIS4, KDKREDNLDAT4, KDVERS4, KDVERS24, KDKREDSB4, KDVERSTAGE4, KDVERSNR4, KDKREDLIM5, KDKREDVON5, KDKREDBIS5, KDKREDNLDAT5, KDVERS5, KDVERS25, KDKREDSB5, KDVERSTAGE5, KDVERSNR5, KDKREDEHA, KDKREDEHAR, KDKREDNOLI, KDKREDNOLIV, KDKREDNOLIB, KDAUFBESTTO, KDVERSUMLTO, KDOPSALDOTO, KDZUSKRED, KDZKREVON, KDZKREBIS, KDZKREDSB, KDOPSALDO, KDWEOBLIGO, KDVERSUML, KDSPERRKZ, KDSPERRGRD, KDLAUFDAT, KDBUCHHDAT, KDBRANCHE, KDFAKTART, KDKORT, KDLIMITKZ, KDSPLIEFKZ, KDAUFBEST, KDAUFBESTU, KDPREISPRF, KDMATPRF, KDBRTPRF, KDGQMPRF, KDSTKGPRF, KDSCHLIPRF, KDSCHLIABW, KDDRPAR, KDMWSTID, KDMWSTID2, KDLBMUSTR, KDFBMUSTR, KDSTLAND, KDSTREGBZ, KDSTKREIS, KDSTORT, KDLSART, KDREGMWST, KDMUSTERKZ, KDUMSVVJH, KDUMSVJH, KDUMSLJH, KDPRFZEUG, KDKONZMIT, KDRAITING, KDRECHWERT1, KDRECHWERT2, KDRECHWERT3, KDRECHWERT4, KDRECHWERT5, KDKREDKDNR, KDKOND, KDKDARTBEZ, KDKFIBUDAT, KDKFIBUZEIT, KDILN, KDDEBNRLAE, KDFACLIMIT, KDSHIPINVD, KDAUFBUTO, KDMAXBST, KDGRUPPE, KDEORI, KDEORINL, KDNTSCV, KDNTSCE, KDFILLER, KDAENZL, KDAENB, KDAEND, KDNEUB, KDNEUD)"
                                + " VALUES ((:KDMANDANT, :KDKUNDNR, :KDKUNDNA,  'CN ', '42116       ', 'ZHANGJIAGANG                            ', '1 ', 'JIANGSU      ', 'A', 20100603, 'C', '1', 'ó￠ì??1￡¨?D1ú￡?1??ê1???                  ', 'intex-j        ', 'intex (china) consulting Ltd.           ', '???ò??1úì?±±?·1o?                       ', '                                        ', '            ', '               ', '0512-58187818       ', '                    ', '                    ', '                    ', '                    ', '                                        ', '                                                                                                    ', '                    ', '    ', '    ', '        ', ' ', 'V', 'A                   ', ' ', '          ', '  ', '  ', '        ', '                ', 0, '00270070', '00000000', 'N', 0, '  ', ' ', '00000', '270070  ', '        ', '           ', '                                  ', '           ', '                                  ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, '  ', '  ', 0, 0, 50000, 0, 0, 0, 0, 0, '        ', 0, 0, 0, 'N', '   ', 20100603, 0, '   ', '   ', 'ZHANGJIAGA', 'N', ' ', 50000, 0, 'J', 'J', 'J', 'J', 'J', 'J', 'J', '     ', '                    ', '                    ', '   ', '   ', '  ', '  ', '  ', '   ', '   ', '   ', ' ', '00000000000', '00001500000', '00000000000', ' ', 'N', '   ', '0000000000', '0000000000', '0000000000', '0000000000', '0000000000', '00270070', 'K', 'K', 0, 0, '             ', '0', 0, '000', 0, '00000', ' ', '                 ', '0000', ' ', ' ', '                                                                       ', 6, 'JAKV    ', 20111102, 'JAKV    ', 20100603)";
                    break;
                case "50.25":
                default:
                    or1.CommandText = "INSERT INTO KDSTAMM(KDMANDANT, KDKUNDNR, KDKUNDNA, KDLAND, KDPLZ, KDORT, KDBZ, KDBZBEZ, KDSTAKZ, KDSTADAT, KDABCKL, KDANREDE, KDNAME1, KDKNAME, KDNAME2, KDSTRASSE1, KDSTRASSE2, KDPLZPOSTF, KDPOSTFACH, KDTEL, KDTELEX, KDFAX, KDBTX, KDDATEX, KDMBOX, KDMAILADR, KDTTEX, KDCOUNTY, KDCITY, KDZENTR, KDZENTRR, KDSPRKZ, KDBBN, KDSONDSTA, KDKDNRALT, KDLO, KDLB, KDLP, KDLIEFNR, KDINVDAT, KDDEBNR, KDKREDNR, KDUEBKZ, KDAUSK, KDAUSKKZ, KDMAHNST, KDMAHNH, KDGRPCUNO, KDCLEARCUNO, KDBIC1, KDIBAN1, KDBIC2, KDIBAN2, KDKREDLIM1, KDKREDVON1, KDKREDBIS1, KDKREDNLDAT1, KDVERS1, KDVERS21, KDKREDSB1, KDVERSTAGE1, KDVERSNR1, KDKREDLIM2, KDKREDVON2, KDKREDBIS2, KDKREDNLDAT2, KDVERS2, KDVERS22, KDKREDSB2, KDVERSTAGE2, KDVERSNR2, KDKREDLIM3, KDKREDVON3, KDKREDBIS3, KDKREDNLDAT3, KDVERS3, KDVERS23, KDKREDSB3, KDVERSTAGE3, KDVERSNR3, KDKREDLIM4, KDKREDVON4, KDKREDBIS4, KDKREDNLDAT4, KDVERS4, KDVERS24, KDKREDSB4, KDVERSTAGE4, KDVERSNR4, KDKREDLIM5, KDKREDVON5, KDKREDBIS5, KDKREDNLDAT5, KDVERS5, KDVERS25, KDKREDSB5, KDVERSTAGE5, KDVERSNR5, KDKREDEHA, KDKREDEHAR, KDKREDNOLI, KDKREDNOLIV, KDKREDNOLIB, KDAUFBESTTO, KDVERSUMLTO, KDOPSALDOTO, KDZUSKRED, KDZKREVON, KDZKREBIS, KDZKREDSB, KDOPSALDO, KDWEOBLIGO, KDVERSUML, KDSPERRKZ, KDSPERRGRD, KDLAUFDAT, KDBUCHHDAT, KDBRANCHE, KDFAKTART, KDKORT, KDLIMITKZ, KDSPLIEFKZ, KDAUFBEST, KDAUFBESTU, KDPREISPRF, KDMATPRF, KDBRTPRF, KDGQMPRF, KDSTKGPRF, KDSCHLIPRF, KDSCHLIABW, KDDRPAR, KDMWSTID, KDMWSTID2, KDLBMUSTR, KDFBMUSTR, KDSTLAND, KDSTREGBZ, KDSTKREIS, KDSTORT, KDLSART, KDREGMWST, KDMUSTERKZ, KDUMSVVJH, KDUMSVJH, KDUMSLJH, KDPRFZEUG, KDKONZMIT, KDRAITING, KDRECHWERT1, KDRECHWERT2, KDRECHWERT3, KDRECHWERT4, KDRECHWERT5, KDKREDKDNR, KDKOND, KDKDARTBEZ, KDKFIBUDAT, KDKFIBUZEIT, KDILN, KDDEBNRLAE, KDFACLIMIT, KDSHIPINVD, KDAUFBUTO, KDMAXBST, KDGRUPPE, KDEORI, KDEORINL, KDNTSCV, KDNTSCE, KDKEYAC, KDKTOGRP, KDFILLER, KDAENZL, KDAENB, KDAEND, KDNEUB, KDNEUD)"
                                                    + " VALUES (:KDMANDANT, :KDKUNDNR, :KDKUNDNA, 'CN ', '            ', 'FOSHAN                                  ', '  ', '             ', 'A', 20130219, 'A', '1', 'NAME1                                   ', 'HLT            ', 'NAME2                                   ', 'STREET                                  ', 'ADDRESS                                 ', '            ', '               ', '0757-86880599       ', '                    ', '0757-86845974       ', '                    ', '                    ', '                                        ', 'kent@carpediem.hk                                                                                   ', '                    ', '    ', '    ', '00000000', 'J', 'E', 'A                   ', ' ', '          ', '  ', '  ', '        ', '                ', 0, '00000200', '00000200', 'N', 0, '  ', ' ', '00000', '200     ', '        ', '           ', '                                  ', '           ', '                                  ', 90000000, 0, 20231212, 0, '01', '  ', 'SUNLV   ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, 0, 0, 0, '  ', '  ', '        ', 0, '          ', 0, '  ', '  ', 0, 0, 4792400, 471548, 0, 200000, 20120312, 20220512, 'SUNLV   ', 0, 0, 471412, 'N', '   ', 20130105, 0, 'MIL', '   ', 'FOSHAN    ', 'F', 'N', 4567550, 0, 'J', 'J', 'J', 'J', 'J', 'J', 'J', '     ', '                    ', '                    ', '   ', '   ', '  ', '  ', '  ', '   ', '   ', '17%', ' ', '00000000000', '00009037120', '00002699800', ' ', 'N', '003', '0000000000', '0000000000', '0000000000', '0000000000', '0000000000', '00000200', 'K', 'K', 0, 0, '             ', '0', 0, '000', 0, '00000', ' ', '                 ', '0000', ' ', ' ', '        ', '  ', '                                                             ', 421, 'SUNLV   ', 20130219, 'WI      ', 19980128)";
                    break;
            }
            or1.Parameters.Add("KDMANDANT", OracleType.NVarChar).Value = dwData["KDMANDANT"].ToString();
            or1.Parameters.Add("KDKUNDNR", OracleType.NVarChar).Value = dwData["KDKUNDNR"].ToString();
            or1.Parameters.Add("KDKUNDNA", OracleType.NVarChar).Value = dwData["KDKUNDNA"].ToString();
            Connect2Proxy(or1); 
        }
        public void InsertKUNDVER(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            or1 = OracleDB.CreateCommand();
            DataSet result = new DataSet();
            or1.CommandText = "INSERT INTO KUNDVER(KDVMANDANT, KDVKUNDNR, KDVVB, KDVVG, KDVSTAKZ, KDVSTADAT, KDVWAEHRSL, KDVZAHLBED, KDVEKON, KDVKDVKL, KDVVALUTA, KDVSTEUER, KDVLIEFBED, KDVLANDU, KDVPLZU, KDVORTU, KDVBZU, KDVBZBEZU, KDVCOUNTRY, KDVCITY, KDVPREISGRP, KDVMINDST, KDVSTDBON, KDVLIEFKOMP, KDVLIEFAUTO, KDVABNGRP, KDVABSSCHL, KDVMUSTER, KDVKOLLZYKL, KDVBONVON, KDVBONIN, KDVBONBIS, KDVABRVB, KDVABRVG, KDVRABABRKZ, KDVBONABRKZ, KDVGBABRKZ, KDVFBABRKZ, KDVVBABRKZ, KDVGABONA, KDVGABONP, KDVFIXBONP, KDVVORBONP, KDVRABART1, KDVRABPROZ1, KDVRABART2, KDVRABPROZ2, KDVRABART3, KDVRABPROZ3, KDVRABART4, KDVRABPROZ4, KDVRABART5, KDVRABPROZ5, KDVBONWE1, KDVBONP1, KDVBONWE2, KDVBONP2, KDVBONWE3, KDVBONP3, KDVBONWE4, KDVBONP4, KDVBONWE5, KDVBONP5, KDVBONWE6, KDVBONP6, KDVBONWE7, KDVBONP7, KDVBONWE8, KDVBONP8, KDVBONWE9, KDVBONP9, KDVBONWE10, KDVBONP10, KDVUMSGR, KDVDISTRWEG, KDVSTATGEB, KDVSACHB, KDVVORBONV1, KDVVORBONV2, KDVVORBONV3, KDVBONLDAT, KDVVBONLDAT, KDVZUREGEL, KDVZEITRAUM, KDVWOCHTAG, KDVKZVORW, KDVMONTAG1, KDVMONTAG2, KDVDATLSR, KDVVTRNR1, KDVVTRNR2, KDVVTRNR3, KDVVTRNR4, KDVAZVERB, KDVBASIS, KDVSPLITT, KDVMEEH, KDVAUFMEEH, KDVABRUF, KDVZESSIO, KDVMAXWERT, KDVPREH, KDVFBPROV, KDVSPLKEY, KDVFILLER, KDVAENDZL, KDVAENDBEN, KDVAENDDAT, KDVNEUBEN, KDVNEUDAT)"
                + " VALUES (:KDVMANDANT, :KDVKUNDNR, :KDVVB, :KDVVG, 'A', 20100121, 'RMB', 'STD', '        ', '   ', 0, '17%', 'EXW', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', 'SA      ', '1', '        ', 'N', 'N', '   ', '   ', 0, '                         ', 0, 0, 0, '   ', '   ', ' ', ' ', ' ', ' ', ' ', 0, 0, 0, 0, '   ', 0, '   ', 0, '   ', 0, '   ', 0, '   ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '   ', '   ', 'INTEXV  ', 0, 0, 0, 0, 0, 'J', ' ', '0', 'N', '00', '00', 20130105, '        ', '        ', '        ', '        ', '0', ' ', ' ', '   ', '   ', 'N', ' ', 0, '   ', ' ', ' ', '                                                                                                                          ', 16, 'SUNLV   ', 20130105, 'INTEXE  ', 20100121)";
            or1.Parameters.Add("KDVMANDANT", OracleType.NVarChar).Value = dwData["KDVMANDANT"].ToString();
            or1.Parameters.Add("KDVKUNDNR", OracleType.NVarChar).Value = dwData["KDVKUNDNR"].ToString();
            or1.Parameters.Add("KDVVB", OracleType.NVarChar).Value = dwData["KDVVB"].ToString();
            or1.Parameters.Add("KDVVG", OracleType.NVarChar).Value = dwData["KDVVG"].ToString();
            Connect2Proxy(or1); 
        }
        #endregion

        #region======L==============
        #endregion

        #region======M==============
        #endregion

        #region======P==============
        #endregion

        #region======Q==============
        #endregion

        #region=====S==============
        #endregion

        #region======W==============
        
        public void InsertWASTAMM(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WASTAMM(WAMANDANT, WAKUNDNR, WAWERK, WAABT, WAART, WAVAR, WAAENZL, WAAENB, WAAEND, WANEUB, WANEUD, WABEZ, WAMTART, WAMU, WARKZ, WAFKZ, WAMUART, WAMUNR, WAHERLD, WAFDDIM, WAMURLOD, WAMUPROD, WAMUCTOD, WAMUDTRL, WAMUBIRL, WAGASTA, WAMASTA, WAKESTA, WAROSTA, WARBSTA, WAFBSTA, WARPROF, WAFPROF, WARLSTA, WAFLSTA, WARSTAKZ, WAWAART, WARFERTKZ, WARKL, WARMEHRB, WARVOLL, WARAUFM, WATRAUFM, WATRLG, WARSTDLG, WARSTDGW, WARABLOM, WARMUNR, WARBEM, WATEXTE1, WATEXTE2, WATEXTE3, WATEXTE4, WAKRITI, WARGKZ1, WAGFKZ, WARAUFT, WARAUFD, WARUNGLFM, WARUNGQM, WARUNBRT, WARUNFDK, WARUNFDS, WARWBRT, WARBRLST, WARBRTOL, WARGRQM, WARGRLFD, WARGWTOL, WARARTDICKE, WARARTTOLP, WARARTTOLM, WARFDDIK, WARFDDIS, WABIND, WARIPP, WASCHLICHTGR, WASCHLICHTNR, WAEINZNR, WATSDSCH, WASTTEIL, WAFSTAKZ, WAFFERTKZ, WAAUSART, WASTUEART, WAVWART, WAVWVAR, WAVARFR, WAFMEHRB, WAFVOLL, WAFAUFM, WAFSTDLG, WAFSTDGW, WAFABLOM, WAGVORL, WAOVORL, WAFRBST, WALAMFR, WAFGKZ1, WAFGKZ2, WAFGKZ3, WASCHLKZ, WAFAUFT, WAFAUFD, WAFKART, WAKOLL, WAFBEM, WAFUNGLFM, WAFUNGQM, WAFUNBRT, WAFUNFDK, WAFUNFDS, WAFBRTU, WAFBRTUT, WAFBRTL, WAFBRTLT, WASCHNK, WALAEAEND, WARENDEM, WARENDEMNT, WAGWVERL, WAALKV, WAFGRQM, WAFGRLFD, WAFGWTOL, WAFARTDICKE, WAFARTTOLP, WAFARTTOLM, WAFFDDIK, WAFFDDIS, WAUNI, WACOLORKZ, WAUNIGA, WAGEWICHT2, WAFVERF1, WAFVERF2, WAFVERF3, WAFVERF4, WAFZUSTAND1, WAFZUSTAND2, WAFZUSTAND3, WAFZUSTAND4, WAFVERFN1, WAFVERFN2, WAFVERFN3, WAFVERFN4, WAFFGRPN1, WAFFGRPN2, WAFFGRPN3, WAFFGRPN4, WAVNRKZ, WAZUSTKZ, WAUEKLOKZ, WAFSUBST, WAMAXFA, WAAKZWG, WAFRESTF, WADRUCKBAR, WAVBRGQM, WALEDR, WADVERF1, WADVERF2, WADVERF3, WADVERF4, WADZUSTAND1, WADZUSTAND2, WADZUSTAND3, WADZUSTAND4, WADVERFN1, WADVERFN2, WADVERFN3, WADVERFN4, WADFGRPN1, WADFGRPN2, WADFGRPN3, WADFGRPN4, WADSUBST, WADRESTF, WAFAKTOR, WABSUBST, WAVORBWA, WANACHBWA, WAVORBFB, WANACHBFB, WAVORBDR, WANACHBDR, WAVORBAP, WANACHBAP, WAMVB, WAMNB, WACVB, WACNB, WABVB, WABNB, WASVB, WASNB, WASUBSTGR, WAHANDICAP, WAZUSCHAB, WALOSGRFB, WAQCCHECK, WADART, WADVAR, WADSTDKZ, WADSACHB, WASCHNKZ, WAPROGRP, WAARTGRP, WAWBZEIT, WAMINBST, WAMAXBST, WAOPTMGR, WAOPTMGF, WARMINPMENG, WAFMINPMENG, WAUEBM, WAUEBG, WAUEBF, WAMATPRF, WABRTPRF, WAGQMPRF, WASTKGP, WASCHLIP, WASCHLIA, WALPABR, WADISPZS, WADRPAR, WAZUSTR, WAWDSUM, WASTSKZ, WASTSART, WASTSAUF, WASTSLG, WASTSBRT, WASTSDKZ, WAFILLER1, WAVOLU, WAANAB, WAALBIS, WAPLGRP, WAPRODH, WAMATKL, WAPMGRP, WAPRFSCHL, WAKAART, WAKAVAR, WAKASTD, WAKAZGRP, WAKAPRGRPN1, WAKAPRGRPN2, WAKAPRGRPN3, WAKAAGRA, WAKAAGRP, WAZWTWAHL, WAVERL, WAABR, WAABRTOL, WAKABRT, WARKABRTOL, WAFKABRTOL, WAMATKTO, WAKTO1, WAGV, WAKBON, WAMGKMM, WAMEZ, WAWAG, WABKLAS, WABWPLAN, WAEKGRP, WABSTME, WAVABME, WAEKWSL, WALIEFNR, WAEG, WABON, WAKUNDE, WALOHNW, WALOHNA, WASCHLIAUF, WAPFCODE, WAAUFKZ, WAMRKM1, WAMRKM2, WAMRKM3, WAMRKM4, WAMRKM5, WAESACHB, WAESACHBKZ, WAFBGRLFM, WAPRUEFKZ, WAPRUEFBEN, WAPRUEFDAT, WARAVGRP, WATAX, WAPARTBA, WAFDDIF, WAFILLER2)"
                + "VALUES (:WAMANDANT, '00000000', '   ', '   ', :WAART, :WAVAR, 1, '        ', 0, :WANEUB, :WANEUD, '                                        ', '    ', ' ', 'J', 'J', '                    ', '                    ', '   ', 'INC', '00', '00', ' ', 0, '        ', 'V', 'V', 'V', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'A', 'GEW', 'E', '    ', ' ', 'P', '  ', '  ', 0, 200000, 25400, '          ', '               ', '                                        ', '          ', '          ', '          ', '          ', 'N', ' ', 'J', '        ', 0, ' ', ' ', ' ', ' ', ' ', 0, 0, 0, 0, 0, 0, '0000', '0000', '0000', 0, 0, '               ', 0, '     ', '000000000000000', '               ', 0, 'J', 'A', 'E', 'FI  ', '   ', '                    ', '  ', 'J', ' ', 'P', '  ', 0, 0, '          ', '          ', '          ', 'C ', 'N', ' ', ' ', ' ', ' ', '        ', 0, '          ', '     ', '                                        ', ' ', ' ', ' ', ' ', ' ', 0, 0, 0, 0, 0,0, 0, 0, 0, '00', 0, 0, 0, '0000', '0000', '0000', 0, 0, ' ', ' ', ' ', 0, '   ', '   ', '   ', '   ', '    ', '    ', '    ', '    ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '               ', 0, 0, 0, ' ', 0, 0, '   ', '   ', '   ', '   ', '    ', '    ', '    ', '    ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', '               ', 0, 0, '               ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', 0, 0, ' ', '                    ', '  ', 'J', '        ', ' ', '   ', '   ', '00', 0, 0, 5000, 5000, 0, 0, 'MTR', '2', '000001000000', ' ', ' ', ' ', ' ', ' ', ' ', 'N', 'N', '     ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '         ', 0, 0, 0, '  ', '                  ', '         ', '    ', '         ', '                    ', '  ', 'J', 'GGG', ' ', ' ', ' ', '     ', '  ', 80, 50, 0, '0', 0, 0, 0, '      ', '      ', '      ', 0, '        ', 0, 0, '    ', ' ', '   ', '   ', ' ', '    ', '        ', 'N', 'N', '        ', '                    ', '                    ', 0, '     ', ' ', '    ', '    ', '    ', '    ', '    ', '        ', 'B', 0, 'N', '        ', 0, '10  ', 'RMB', ' ', 25400, '                                                      ')";
            or1.Parameters.Add("WAMANDANT", OracleType.NVarChar).Value = dwData["WAMANDANT"].ToString();
            or1.Parameters.Add("WAART", OracleType.NVarChar).Value = dwData["WAART"].ToString();
            or1.Parameters.Add("WAVAR", OracleType.NVarChar).Value = dwData["WAVAR"].ToString();
            or1.Parameters.Add("WANEUB", OracleType.NVarChar).Value = dwData["WANEUB"].ToString();
            or1.Parameters.Add("WANEUD", OracleType.Number).Value = dwData["WANEUD"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWASTKE(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WASTKE(WAKMANDANT, WAKKUNDNR, WAKWERK, WAKABT, WAKART, WAKVAR, WAKWCOL, WAKPOS, WAKKART, WAKKVAR, WAKKFARBE, WAKBAUMKZ, WAKVERWEN, WAKANZBA, WAKDIVISOR, WAKEAFAKTM, WAKEAFAKTR, WAKDISPOKZ, WAKSTBR, WAKLLEIST, WAKRLEIST, WAKRBEM, WAKNET, WAKBRUT, WAKROSTA, WAKSBSTUE, WAKEARUE, WAKSTICH, WAKSCHIEART, WAKSCHIENE, WAKLAENG, WAKEINL, WAKSPANNV, WAKSPANNB, WAKSPANNF, WAKVERSATZ, WAKVARKZ, WAKABFFDZ, WAKUSEDFDZ, WAKFILLER, WAKAENZL, WAKAENB, WAKAEND, WAKNEUB, WAKNEUD)"
                + " VALUES (:WAKMANDANT, '00000000', '   ', '   ', :WAKART, :WAKVAR, :WAKWCOL, :WAKPOS, '                    ', '  ', '          ', 'Z', 'S', '01', '01', 0, 0, 'B', 'D', '    ', '    ', '                 ', 0, 0, 'N', 'V', 0, 0, ' ', '     ', 0, 0, 0, 0, '00', 0, ' ', 0, 0, '                      ', 0, '        ', 0, '        ', 0)";
            or1.Parameters.Add("WAKMANDANT", OracleType.NVarChar).Value = dwData["WAKMANDANT"].ToString();
            or1.Parameters.Add("WAKART", OracleType.NVarChar).Value = dwData["WAKART"].ToString();
            or1.Parameters.Add("WAKVAR", OracleType.NVarChar).Value = dwData["WAKVAR"].ToString();
            or1.Parameters.Add("WAKWCOL", OracleType.NVarChar).Value = dwData["WAKWCOL"].ToString();
            or1.Parameters.Add("WAKPOS", OracleType.NVarChar).Value = dwData["WAKPOS"].ToString();
            setResult = Connect2Proxy(or1);
        }
        public void InsertWASTGA(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;

            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WASTGA(WAGMANDANT, WAGKUNDNR, WAGWERK, WAGABT, WAGART, WAGVAR, WAGWCOL, WAGPSA, WAGPOS, WAGFOLGEPOS, WAGGART, WAGGVAR, WAGGFARBE, WAGFDZ, WAGABFKZ, WAGABF, WAGABFLG, WAGKGNET, WAGKGBRUT, WAGDISPOKZ, WAGBEM, WAGEAFAKTOR, WAGGRLFDM, WAGKZQM, WAGPROZWG, WAGABFALL, WAGAUFM, WAGANT, WAGEINL, WAGSPANNV, WAGSPANNB, WAGSPANNF, WAGVARKZ, WAGNA1, WAGNA2, WAGNA3, WAGNA4, WAGNA5, WAGNP, WAGWEAVIN, WAGWEEMBR, WAGFLOATING, WAGFL, WAGFLNA1, WAGFLNA2, WAGFLNA3, WAGFLNA4, WAGFLNA5, WAGFLNP, WAGFILLER) "
                + " VALUES (:WAGMANDANT, '00000000', '   ', '   ', :WAGART, :WAGVAR, :WAGWCOL, '1', :WAGPOS, :WAGFOLGEPOS, '                    ', '   ', '          ', 0, ' ', 0, 0, 0, 0, 'B', '          ', 0, 0, ' ', 0, 0, '  ', 0, 0, 0, 0, '00', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, '  ', 0, 0, 0, 0, 0, 0, '                                              ')";
            or1.Parameters.Add("WAGMANDANT", OracleType.NVarChar).Value = dwData["WAGMANDANT"].ToString();
            or1.Parameters.Add("WAGART", OracleType.NVarChar).Value = dwData["WAGART"].ToString();
            or1.Parameters.Add("WAGVAR", OracleType.NVarChar).Value = dwData["WAGVAR"].ToString();
            or1.Parameters.Add("WAGWCOL", OracleType.NVarChar).Value = dwData["WAGWCOL"].ToString(); ;
            or1.Parameters.Add("WAGPOS", OracleType.NVarChar).Value = dwData["WAGPOS"].ToString();
            or1.Parameters.Add("WAGFOLGEPOS", OracleType.Number).Value = dwData["WAGFOLGEPOS"].ToString();
            setResult = Connect2Proxy(or1);
        }
        public void InsertWTSCHUSS(DataRow dwData,string ITXDBVERSION="50.24")
        {
            //WTSMANDANT WTSSFLGNR  WTSNEUBEN WTSNEUDAT 
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WTSCHUSS(WTSMANDANT, WTSSFLGNR, WTSSTAKZ, WTSBEZ, WTSCADKEY1, WTSCADKEY2, WTSMUSTER, WTSSRAPP, WTSGRAPP, WTSJAC, WTSPATRONE, WTSREGU, WTSANZFARB, WTSANZMFS, WTSGRDSCHT, WTSFOLGE, WTSSCHUSS01, WTSSCHUSS02, WTSAENDZL, WTSAENDBEN, WTSAENDDAT, WTSNEUBEN, WTSNEUDAT, WTSFAKTOR, WTSFILLER)"
                + " VALUES (:WTSMANDANT, :WTSSFLGNR, ' ', '                    ', '             ', '      ', 'N', 0, 0, ' ', '               ', '          ', 0, '0', 0, "
            + "'312031202020202000000000473220312020202020000000004720202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020202020202020202000000000202020202020202020000000002020202020202020200000000020', '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',"
            + "1, :WTSAENDBEN, :WTSAENDDAT,:WTSNEUBEN, :WTSNEUDAT, '0000', '                                                                                           ')";
            or1.Parameters.Add("WTSMANDANT", OracleType.NVarChar).Value = dwData["WTSMANDANT"].ToString();
            or1.Parameters.Add("WTSSFLGNR", OracleType.NVarChar).Value = dwData["WTSSFLGNR"].ToString();
            or1.Parameters.Add("WTSAENDBEN", OracleType.NVarChar).Value = dwData["WTSAENDBEN"].ToString();
            or1.Parameters.Add("WTSAENDDAT", OracleType.Number).Value = dwData["WTSAENDDAT"].ToString();
            or1.Parameters.Add("WTSNEUBEN", OracleType.NVarChar).Value = dwData["WTSNEUBEN"].ToString();
            or1.Parameters.Add("WTSNEUDAT", OracleType.Number).Value = dwData["WTSNEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWAFARBEN(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WAFARBEN(WAFMANDANT, WAFKUNDNR, WAFWERK, WAFABT, WAFART, WAFVAR, WAFZUART, WAFZUSATZ, WAFCOLORIT, WAFSTATUS, WAFSFKZ, WAFBEZ, WAFTEXTSCHL, WAFFKARTNR, WAFROHFARBE, WAFMUDESS, WAFUNIFARB, WAFVGRQM, WAFVOLU, WAFZTWAHL, WAFRAPPH, WAFRAPPB, WAFRUESTGRP, WAFPRUEFGRP, WAFSCHABANZ, WAFUSCHABANZ, WAFFDVF, WAFPRGRP, WAFGRPBEZ, WAFPREIS, WAFZUABPR, WAFZUABAB, WAFNFART, WAFWERT, WAFKZPA, WAFZUABVH, WAFZUABAK, WAFZUABKU, WAFZUABPROZ, WAFEZUSTAND1, WAFEZUSTAND2, WAFEZUSTAND3, WAFEZUSTAND4, WAFEZUSTAND5, WAFEZUSTAND6, WAFEZUSTAND7, WAFEZUSTAND8, WAFEZUSTAND9, WAFEZUSTAND10, WAFFA, WAFGA, WAFQA, WAFQPKTH, WAFQPKTLH, WAFLOAN, WAFLBAN, WAFLPAN, WAFABKZAN, WAFPKL, WAFVBBRT, WAFBRTTOLPL, WAFBRTTOLMI, WAFVBGRQM, WAFVBGRLFD, WAFGWTOLPL, WAFGWTOLMIN, WAFVBFDDIK, WAFFDKTOLPL, WAFFDKTOLMI, WAFVBFDDIS, WAFFDSTOLPL, WAFFDSTOLMI, WAFLAEAEND, WAFGWVERL, WAFRESTSCHL, WAFPHWERTMI, WAFPHWERTMA, WAFWEISSGRD, WAFNETZFVON, WAFNETZFBIS, WAFNETZFSEK, WAFRSSFTRKV, WAFRSSFTRKB, WAFRSSFTRSV, WAFRSSFTRSB, WAFUNIFAEH, WAFFADGERAD, WAFMUSTFRB, WAFVORB, WAFNACHB, WAFMU, WAFMURLOD, WAFMUPROD, WAFMUCTOD, WAFMUDTRL, WAFMUBIRL, WAFHUNGLFM, WAFHUNGQM, WAFHUNBRT, WAFHUNFDK, WAFHUNFDS, WAFLMANRKRS, WAFLMALFDNR, WAFLMAPOS, WAFLODKRS, WAFLODLFD, WAFLODPOS, WAFKZDUMCOL, WAFPSEUDOCOL, WAFPRFSCHL, WAFFILLER, WAFAENDZL, WAFAENDBEN, WAFAENDDAT, WAFNEUBEN, WAFNEUDAT)"
                + "VALUES (:WAFMANDANT, '00000000', '   ', '   ',:WAFART,:WAFVAR, :WAFZUART,:WAFZUSATZ, '          ', 'A', 'N', :WAFBEZ"
            + ", '          ', '          ', '          ', '          ', '          ', 0, 0, 0, 0, 0, '   ', ' ', 0, 0, '   ', ' ', '                    ', 0, 0, 0, '    ', 0, ' ', 0, 0, 0, ' ', '    ', '    ', '    ', '    ', '    ', '    ', '    ', '    '"
            + ", '    ', '    ', 0, 0, 0, 0, 0, '  ', '  ', '        ', ' ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', ' ', '          ', '   ', '   ', ' ', '00', '00', ' '"
            + ", 0, '        ', ' ', ' ', ' ', ' ', ' ', '  ', '    ', '  ', '  ', '      ', '   ', ' ', '          ', '         ', '                                                           ', 0, '        ', 0, :WAFNEUBEN, :WAFNEUDAT)";
            or1.Parameters.Add("WAFMANDANT", OracleType.NVarChar).Value = dwData["WAFMANDANT"].ToString();
            or1.Parameters.Add("WAFART", OracleType.NVarChar).Value = dwData["WAFART"].ToString();
            or1.Parameters.Add("WAFVAR", OracleType.NVarChar).Value = dwData["WAFVAR"].ToString();
            or1.Parameters.Add("WAFZUART", OracleType.NVarChar).Value = dwData["WAFZUART"].ToString();
            or1.Parameters.Add("WAFZUSATZ", OracleType.NVarChar).Value = dwData["WAFZUSATZ"].ToString();
            or1.Parameters.Add("WAFBEZ", OracleType.NVarChar).Value = dwData["WAFBEZ"].ToString();
            or1.Parameters.Add("WAFNEUBEN", OracleType.NVarChar).Value = dwData["WAFNEUBEN"].ToString();
            or1.Parameters.Add("WAFNEUDAT", OracleType.Number).Value = dwData["WAFNEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWASTPASS(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO WASTPASS(WSPMANDANT, WSPKUNDNR, WSPWERK, WSPABT, WSPART, WSPVAR, WSPPOS, WSPPASS)"
                + "VALUES (:WSPMANDANT, '00000000', '   ', '   ', :WSPART, :WSPVAR, :WSPPOS,:WSPPASS)";
            or1.Parameters.Add("WSPMANDANT", OracleType.NVarChar).Value = dwData["WSPMANDANT"].ToString();
            or1.Parameters.Add("WSPART", OracleType.NVarChar).Value = dwData["WSPART"].ToString();
            or1.Parameters.Add("WSPVAR", OracleType.NVarChar).Value = dwData["WSPVAR"].ToString();
            or1.Parameters.Add("WSPPOS", OracleType.Number).Value = dwData["WSPPOS"].ToString();
            or1.Parameters.Add("WSPPASS", OracleType.NVarChar).Value = dwData["WSPPASS"].ToString();
            Connect2Proxy(or1);
        }

        public void InsertWDECK(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WDECK(WDMANDANT, WDSA, WDAUFKRS, WDAUFLFD, WDAUFPOS, WDTYP, WDUPOS, WDKUNDNR, WDWERK, WDABT, WDWAKZ, WDART, WDDESS, WDCOLORIT, WDFARBE, WDBESCHICH, WDVAR, WDZUSTAND, WDDAT, WDLO, WDZS, WDAFOLGE, WDBEDARF, WDZUGET, WDRESERV, WDVERBR, WDANZSTK, WDKZBEDARF, WDURAUFKRS, WDURAUFLFD, WDURAUFPOS, WDVKNPOS, WDPGLKZ, WDABRKZ, WDDISPOKZ, WDERLKZ, WDSLPOS, WDPRART, WDPRVAR, WDBEDBAS, WDLAGE, WDVARFR, WDBEDST, WDFILLER)"
                                                            + "  VALUES (:WDMANDANT, 'K',     :WDAUFKRS,:WDAUFLFD, :WDAUFPOS, 'B',         '00',            '00000000', '   ',              '   ',           ' ',       '                    ', '          ', '          ', '          ', '          ', '  ', '    ', '        ', '  ', ' ', '000', 0, 0, 0, 0, '000', ' ', '  ', '000000', '000', 0, ' ', ' ', ' ', ' ', 0, '                    ', '  ', '00000000', '00', ' ', ' ', '0000000000000  ')";
            or1.Parameters.Add("WDMANDANT", OracleType.NVarChar).Value = dwData["WDMANDANT"].ToString();
            or1.Parameters.Add("WDAUFKRS", OracleType.NVarChar).Value = dwData["WDAUFKRS"].ToString();
            or1.Parameters.Add("WDAUFLFD", OracleType.NVarChar).Value = dwData["WDAUFLFD"].ToString();
            or1.Parameters.Add("WDAUFPOS", OracleType.NVarChar).Value = dwData["WDAUFPOS"].ToString();
            Connect2Proxy(or1);
        }

        public void InsertWBBST(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WBBST(WBBMANDANT, WBBRWKRS, WBBRWLFD, WBBPOS, WBBWERK, WBBABT, WBBKUNDNR, WBBSTKNR, WBBWAKZ, "
            +"WBBART, WBBDESS, WBBCOLORIT, WBBFARBE, WBBBESCHICH, WBBVAR, WBBKOLL, WBBVKART, WBBVKFARBE, WBBARTABW, WBBARTKUNDNR, WBBENTWKZ"
            +", WBBSSTKLG, WBBSGEW, WBBSBRT, WBBISTKLG, WBBIGEW, WBBIBRT, WBBBRGEW, WBBDM, WBBVOL, WBBIGEWKZ, WBBIANZ, WBBMABRT1, WBBMASTKLG1, "
            +"WBBMABRT2, WBBMASTKLG2, WBBMABRT3, WBBMASTKLG3, WBBMABRT4, WBBMASTKLG4, WBBMABRT5, WBBMASTKLG5, WBBINDAT, WBBINBSTMTR, "
            +"WBBINBSTKG, WBBIPREIS, WBBWARSCH, WBBWDATUM, WBBWSCHICHT, WBBWMNRKRS, WBBWMLFDNR, WBBWMPOS, WBBRE, WBBRENETTO, WBBREVGUET, "
            +"WBBRS, WBBRSNETTO, WBBRSVGUET, WBBVE, WBBVENETTO, WBBVEVGUET, WBBVS, WBBVSNETTO, WBBVSVGUET, WBBANZTEILE, WBBVERSION, WBBTAX, "
            +"WBBZENSUR, WBBZENSURKZ, WBBUBRT, WBBZAFOLGE, WBBNAFOLGE, WBBZLNR, WBBAUFMSL, WBBZUSAM, WBBMAART, WBBPACKTYP, WBBROLLR,"
            +"WBBAUFMPOS, WBBKONFKZ, WBBKETTELN, WBBSHSTK1, WBBSHBRT1, WBBSHSTKLG1, WBBSHSTK2, WBBSHBRT2, WBBSHSTKLG2, WBBSHSTK3,"
            +"WBBSHBRT3, WBBSHSTKLG3, WBBSHSTK4, WBBSHBRT4, WBBSHSTKLG4, WBBSHSTK5, WBBSHBRT5, WBBSHSTKLG5, WBBSTKNRK, WBBLO, "
            + "WBBLB, WBBKZ, WBBLP, WBBAUFBKZ, WBBGEBNR, WBBGEBPOS, WBBSPSTA, WBBSPGRD, WBBERLKZ, WBBAUFTYP, WBBAUFKRS, WBBAUFLFD, "
            + "WBBAUFPOS, WBBTP, WBBFOLGE, WBBAFOLGEVON, WBBRAFOLGE, WBBMAFOLGE, WBBRSTKLG, WBBRGEW, WBBLGAE, WBBGEWAE, WBBPOOL,"
            + " WBBAUTZU, WBBWDUPOS, WBBRBENID, WBBRDATB, WBBRDAT, WBBRBEM, WBBRKUNDNR, WBBDPART, WBBDPART2, WBBZUSTAND, WBBFARBN, WBBSPKZ,"
            + " WBBCUKZ, WBBDISPOART, WBBDISPOVAR, WBBAUSFFRB, WBBAUSFGRI, WBBAUSFQUAL, WBBQUALST, WBBQPKT, WBBQPKTH, WBBQPKTL, WBBQPKTLH, "
            + "WBBVB, WBBVG, WBBVLVB, WBBVLVG, WBBVLSACHB, WBBVLGEGEN, WBBPRKUNDNR, WBBGENNR, WBBELOA, WBBELOB, WBBURAUFKRS, WBBURAUFLFD, "
            + "WBBURAUFPOS, WBBVKNPOS, WBBURLAND, WBBVERZKZ, WBBTSTKLG, WBBTANZ, WBBURPOS, WBBTEILPOS, WBBECKZ, WBBTLGAFOLGE, WBBZMT,"
            + " WBBANZSNT, WBBTLBRT, WBBTLSTKLG, WBBTLRICHT, WBBDRKZ1, WBBDRKZ2, WBBEINDAT, WBBWSTKLG, WBBWBRT, WBBWBMNRKRS, WBBWBMLFDNR,"
            + " WBBWBMPOS, WBBSCHUSS, WBBWERKE, WBBLIEF, WBBBAHN, WBBBAHNMAX, WBBWLO, WBBWLB, WBBWLP, WBBWAUFBKZ, WBBKANTE, WBBSOLLKZ, "
            + "WBBMATAB, WBBWJJJJ, WBBWBNR, WBBFLZZUGDAT, WBBISTKLGFA, WBBISTKLGF, WBBFRTWSKZ, WBBLTPOS, WBBILGFBT, WBBILGRBT, WBBIBRTFV, WBBIBRTFB, "
            + "WBBFEUCHTE, WBBLIEFSCH, WBBKDPART, WBBSCHLICHTEKZ, WBBASWAKZ, WBBASART, WBBASVAR, WBBFARBEALT, WBBCOLALT, WBBDESSALT, "
            + "WBBBESALT, WBBZUSTANDA, WBBMASSKZ, WBBFJJJJ, WBBFBNR, WBBRETOURKZ, WBBREAUFKRS, WBBREAUFLFD, WBBREAUFPOS, WBBREAFOLGE, "
            + "WBBTPA, WBBKOMMNR, WBBALIEFSCH, WBBPACKNR, WBBPACKAUTO, WBBRUEKZ, WBBURLB, WBBURLP, WBBURAKZ, WBBVERSDAT, WBBVERSANDKZ, "
            + "WBBURLIEFSCH, WBBARECHNR, WBBFERTKZ, WBBEGKZ, WBBBEM, WBBTXSCHL, WBBHHK1, WBBHHK2, WBBHHK3, WBBHHK4, WBBHHK5, WBBHHK6, "
            + "WBBHHK7, WBBHHK8, WBBHHK9, WBBHHK10, WBBHHKG, WBBAHK1, WBBAHK2, WBBAHK3, WBBAHK4, WBBAHK5, WBBAHK6, WBBAHK7, WBBAHK8,"
            + " WBBAHK9, WBBAHK10, WBBAHKG, WBBABPZAB, WBBABDATAB, WBBNEUBEN, WBBNEUDAT, WBBAENDBEN, WBBAENDDAT, WBBAENDZL, WBBWS," 
            + " WBBWSNO, WBBFILLER)"
                    + " VALUES (:WBBMANDANT, :WBBRWKRS, :WBBRWLFD, :WBBPOS, '   ', '   ', '00000000', '            ', ' ', '                    ', '          ', '          ', '          ', '          ',"
                    + " '  ', '     ', '                        ', '          ', ' ', '        ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '        ', 0, '0', '  ', '0000', '00', 0, 0, 0, 0, 0, 0, " 
                    + "0, 0, 0, 0, 0, 0, '0', '1', '   ', '1', 'A', 0, '000', '000', '               ', '  ', '  ', ' ', '    ', 'I', '0000', ' ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '            ', '  ', '  ', ' ', '        ', 'J', '        ', '000', '  ', '  ', 'J', ' ', '  ', '      ', '   ', '0000', '00', '000', '000', '000', 0, 0, 0, 0, ' ', ' ', '02', '        ', 0, 0, '               ', '        ', '           ', '           ', '    ', '  ', ' ', ' ', '                    ', '  ', 100, 100, 100, ' ', 0, 0, 0, 0, '   ', '   ', '   ', '   ', '        ', ' ', '        ', '            ', '  ', '  ', '  ', '000000', '000', 0, '   ', ' ', 0, '00', '0001', '0000', ' ', '000', 9, 0, 0, 0, ' ', ' ', ' ', 0, 0, 0, '  ', '0000', '00', 0, ' ', '0000', 0, 0, '  ', '  ', '        ', ' ', '  ', ' ', ' ', 0, 0, 0, 0, 0, ' ', 11, 0, 0, 0, 0, 0, '          ', '          ', 'J', ' ', '                    ', '  ', '          ', '          ', '          ', '          ', '    ', ' ', 0, 0, '  ', '  ', '000000', '000', '000', '0000', '000000', '00000000', '0000', ' ', ' ', '  ', '        ', ' ', 0, 'J', '00000000', '00000000', 'Z', ' ', '               ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '        ', 0, '        ', 0, 4, '    ', 0, '                                                                                                           ')";
            or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
            or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString();
            or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString();
            or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWBBEW(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WBBEW(WBEWMANDANT, WBEWJJJJ, WBEWBELEG, WBEWLFDNR, WBEWKUNDNR, WBEWWERK, WBEWABT, WBEWWAKZ, WBEWART, WBEWVAR, WBEWDESS, WBEWCOLORIT, WBEWFARBE, WBEWBESCHICH, WBEWZUSTAND, WBEWZENSUR, WBEWZENSURKZ, WBEWTAX, WBEWAUFMSL, WBEWPACKTYP, WBEWLO, WBEWLB, WBEWLP, WBEWAUFBKZ, WBEWRWKRS, WBEWRWLFD, WBEWPOS, WBEWSTKNR, WBEWTSTKNR, WBEWGEBNR, WBEWGEBPOS, WBEWDPART, WBEWLAGE, WBEWBAHN, WBEWFSCHL, WBEWPACKNR, WBEWAUFTYP, WBEWAUFKRS, WBEWAUFLFD, WBEWAUFPOS, WBEWAFOLGE, WBEWTP, WBEWAPOS, WBEWWDUPOS, WBEWMNRKRS, WBEWMLFDNR, WBEWMPOS, WBEWSCHICHT, WBEWKSTKRS, WBEWKST, WBEWKOSTART, WBEWBS, WBEWWERT, WBEWWERTDAT, WBEWWEKORR, WBEWMTR, WBEWGEW, WBEWBRT, WBEWBUCHDAT, WBEWBUCHUHR, WBEWBUCHBEN, WBEWFC, WBEWKONDAT, WBEWMATABR, WBEWSTORKZ, WBEWINVBLG, WBEWRENRG, WBEWSTGRD, WBEWACTION, WBEWSAPKZ, WBEWFILLER)"
                                            + "VALUES (:WBEWMANDANT, 0, :WBEWBELEG, :WBEWLFDNR, '00000000', '   ', '   ', ' ', '                    ', '  ', '          ', '          ', '          ', '          ', '    ', '1', 'A', '   ', '  ', '    ', '  ', '  ', '        ', 'J', '  ', '      ', '    ', '            ', '            ', '        ', '000', '           ', 0, 0, '   ', '0000', ' ', '  ', '      ', '   ', '000', '0000', '0000', '00', '  ', '0000', '00', '0', '  ', '0000', '      ', '  ', 0, 0, '  ', 0, 0, 0, 0, 0, '        ', '        ', 0, 'J', ' ', 0, '           ', '  ', '  ', ' ', :WBEWFILLER)";
            or1.Parameters.Add("WBEWMANDANT", OracleType.NVarChar).Value = dwData["WBEWMANDANT"].ToString();
            or1.Parameters.Add("WBEWBELEG", OracleType.NVarChar).Value = dwData["WBEWBELEG"].ToString();
            or1.Parameters.Add("WBEWLFDNR", OracleType.NVarChar).Value = dwData["WBEWLFDNR"].ToString();
            or1.Parameters.Add("WBEWFILLER", OracleType.NVarChar).Value = dwData["WBEWFILLER"].ToString();            
            Connect2Proxy(or1);
        }
        public void InsertWBDAT(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WBDAT(WBMANDANT, WBRWKRS, WBRWLFD, WBLESTKNR, WBKUNDNR, WBWERK, WBABT, WBWAKZ, WBART, WBVAR, WBDESS, WBCOLORIT, WBFARBE, WBBESCHICH, WBZUSTAND, WBLIEFSCHNR, WBLIEFDAT, WBWEBER, WBABS, WBEINDAT, WBEINLO, WBKDPART, WBSPSTA, WBSPGRD, WBSTK, WBMTR, WBGEBANZ, WBKGBRUT, WBKGNET, WBKGTARA, WBMEWE, WBSTKK, WBMTRK, WBGEBANZK, WBKGNETK, WBRWAUFMSL, WBGEBART, WBBRT, WBGRQM, WBGRLFD, WBFDDIK, WBFDDIS, WBPRUEF, WBSCHLIGR1, WBSCHLIGR2, WBSCHLIGR3, WBSCHLIGR4, WBSCHLIGR5, WBSCHLINR1, WBSCHLINR2, WBSCHLINR3, WBSCHLINR4, WBSCHLINR5, WBFILLER1, WBSCHLIKZ, WBMATERIAL, WBKRITISCH, WBKDSTK, WBVERSRUE, WBKANTE, WBENTKZ, WBBESTKZ, WBBESTKRS, WBBESTLFD, WBBESTPOS, WBKOKRS, WBKOLFD, WBNETMTR, WBFERTKZ, WBREDAT, WBRENR, WBREWERT, WBSTAPO, WBPLPREIS, WBEINVKZ, WBMATPRF, WBSPEDF, WBSPEDV, WBSPEDZ, WBURRENR, WBURLAND, WBBUSIMODE, WBDRVERT, WBCBOOKNO, WBCITEMNO, WBZOLLST, WBFILLER2, WBAENDZL, WBAENDBEN, WBAENDDAT, WBNEUBEN, WBNEUDAT)"
                                        + " VALUES (:WBMANDANT, :WBRWKRS, :WBRWLFD, '1111', '00000000', '   ', '   ', 'F', 'PV912102            ', '12', '          ', '          ', 'RD01      ', 'F01       ', '    ', 'DL2840    ', 20100917, '        ', '                              ', 20100917, '01', 'LT2840A   ', '  ', '  ', 10, 120000, 1, 0, 47400, 0, '   ', 10, 120000, 0, 47400, '  ', 'TC  ', 15800, 250, 395, 0, 0, 'SUNLV   ', ' ', ' ', ' ', ' ', ' ', '   ', '   ', '   ', '   ', '   ', ' ', 'J', 'J', ' ', 'N', ' ', '  ', ' ', ' ', '  ', '      ', '   ', '  ', '      ', 120000, 'Z', 0, '          ', 0, '  ', 0, 'E', ' ', ' ', ' ', ' ', '          ', 'CN ', '   ', '                    ', '               ', 0, '      ', '                                              ', 12, 'SUNLV   ', 20100917, 'SUNLV   ', 20100917)";
            or1.Parameters.Add("WBMANDANT", OracleType.NVarChar).Value = dwData["WBMANDANT"].ToString();
            or1.Parameters.Add("WBRWKRS", OracleType.NVarChar).Value = dwData["WBRWKRS"].ToString();
            or1.Parameters.Add("WBRWLFD", OracleType.NVarChar).Value = dwData["WBRWLFD"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWTPASS(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WTPASS(WTPMANDANT, WTPPASSNR, WTPSTAKZ, WTPBEZ, WTPEZ, WTPERSFD, WTPPSCHT, WTPLSCHTW, WTPLSCHTK, WTPGSCHT, WTPANZK, WTPRAPP, WTPGLITY, WTPGLATY, WTPGLARH, WTPGLAANZ, WTPPLITY, WTPPLATY, WTPPLARH, WTPPLAANZ, WTPAENDZL, WTPAENDBEN, WTPAENDDAT, WTPNEUBEN, WTPNEUDAT, WTPFILLER)"
                + "VALUES (:WTPMANDANT, :WTPPASSNR, 'A',:WTPBEZ, ' ', 0, 0, 0, 0, 0, 0, 0, '   ', '   ', 0, 0, '   ', '   ', 0, 0 , 0, '        ', 0, :WTPNEUBEN, :WTPNEUDAT, '                             ')";
            or1.Parameters.Add("WTPMANDANT", OracleType.NVarChar).Value = dwData["WTPMANDANT"].ToString();
            or1.Parameters.Add("WTPPASSNR", OracleType.NVarChar).Value = dwData["WTPPASSNR"].ToString();
            or1.Parameters.Add("WTPBEZ", OracleType.NVarChar).Value = dwData["WTPBEZ"].ToString();
            or1.Parameters.Add("WTPNEUBEN", OracleType.NVarChar).Value = dwData["WTPNEUBEN"].ToString();
            or1.Parameters.Add("WTPNEUDAT", OracleType.NVarChar).Value = dwData["WTPNEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWTEINZ(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WTEINZ(WTEMANDANT, WTEEINZNR, WTESTAKZ, WTEBEZ, WTEEZ, WTEERSFD, WTERAPP, WTEEZWBL, WTEESTBRT, WTEWBLBRT, WTEWBLTL, WTELSL01, WTEGEW01, WTELSR01, WTELEER01, WTELSL02, WTEGEW02, WTELSR02, WTELEER02, WTELSL03, WTEGEW03, WTELSR03, WTELEER03, WTELSL04, WTEGEW04, WTELSR04, WTELEER04, WTELSL05, WTEGEW05, WTELSR05, WTELEER05, WTEAENDZL, WTEAENDBEN, WTEAENDDAT, WTENEUBEN, WTENEUDAT, WTEFILLER)"
                + " VALUES ("
            + " :WTEMANDANT,:WTEEINZNR, 'A', '                              ', 'G', 0, 1, '2                                       ', '                                        ', 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '        ', 0, :WTENEUBEN, :WTENEUDAT, '                                          ')";
            or1.Parameters.Add("WTEMANDANT", OracleType.NVarChar).Value = dwData["WTEMANDANT"].ToString();
            or1.Parameters.Add("WTEEINZNR", OracleType.NVarChar).Value = dwData["WTEEINZNR"].ToString();
            or1.Parameters.Add("WTENEUBEN", OracleType.NVarChar).Value = dwData["WTENEUBEN"].ToString();
            or1.Parameters.Add("WTENEUDAT", OracleType.NVarChar).Value = dwData["WTENEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWTSAER(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO WTSAER SELECT :WTBMANDANT, :WTBSRFNR, '00', ' ', '                    ', 'N', 'AR', '             ', '      ', 0, 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, 1, 11, 0, 0, 0, 0, 2, 12, 0, 0, 0, 0, 3, 13, 0, 0, 0, 0, 4, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,"
            + ":WTBAENDBEN, :WTBAENDDAT, :WTBNEUBEN, :WTBNEUDAT, '                                                                  ' FROM DUAL";
            or1.Parameters.Add("WTBMANDANT", OracleType.NVarChar).Value = dwData["WTBMANDANT"].ToString();
            or1.Parameters.Add("WTBSRFNR", OracleType.NVarChar).Value = dwData["WTBSRFNR"].ToString();
            or1.Parameters.Add("WTBAENDBEN", OracleType.NVarChar).Value = dwData["WTBAENDBEN"].ToString();
            or1.Parameters.Add("WTBAENDDAT", OracleType.NVarChar).Value = dwData["WTBAENDDAT"].ToString();
            or1.Parameters.Add("WTBNEUBEN", OracleType.NVarChar).Value = dwData["WTBNEUBEN"].ToString();
            or1.Parameters.Add("WTBNEUDAT", OracleType.NVarChar).Value = dwData["WTBNEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertWTGEW(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WTGEW(WTGMANDANT, WTGKUNDNR, WTGWERK, WTGABT, WTGART, WTGVAR, WTGAENZL, WTGAENB, WTGAEND, WTGNEUB, WTGNEUD, WTGWBBRT, WTGWBF, WTGFDISM, WTGFDLGS, WTGFDLFS, WTGSFLG, WTGKCOL, WTGSMTRS, WTGREAPPI, WTGRNAME, WTGCHORE, WTGRDENS, WTGRDENSTM, WTGRDENSTP, WTGKARTEN, WTGPLATINEN, WTGNOPPEN, WTGANZRAPP, WTGRWRAPH, WTGRWRAPB, WTGRWRAPHFD, WTGRWRAPBFD, WTGPANELS, WTGSHEDS, WTGNFLRH, WTGNFLRA, WTGNFTOLM, WTGNFTOLP, WTGMFLRH, WTGMFLRA, WTGMFTOLM, WTGMFTOLP, WTGHFLRH, WTGHFLRA, WTGHFTOLM, WTGHFTOLP, WTGFILLER)"
                + "VALUES (:WTGMANDANT, '00000000', '   ', '   ', :WTGART, :WTGVAR, 1, '        ', 0, '        ', 0, 0, 0, 0, 0, 0, 'A              ', '0', 0, '               ', '               ', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '000', '0', 0, '   ', 0, 0, 0, '   ', 0, 0, 0, '   ', 0, 0, '                                                  ')";
            or1.Parameters.Add("WTGMANDANT", OracleType.NVarChar).Value = dwData["WTGMANDANT"].ToString();
            or1.Parameters.Add("WTGART", OracleType.NVarChar).Value = dwData["WTGART"].ToString();
            or1.Parameters.Add("WTGVAR", OracleType.NVarChar).Value = dwData["WTGVAR"].ToString();
            Connect2Proxy(or1);
        }
        #endregion
        
        #region======V==============
        public void InsertVKKOPF(DataRow dwData,string ITXDBVERSION="50.24")
        {
            or1 = OracleDB.CreateCommand();
            DataSet result = new DataSet();
            switch (ITXDBVERSION)
            { 
                case "50.24":
                    or1.CommandText="INSERT INTO VKKOPF(VKKMANDANT, VKKSA, VKKAUFKRS, VKKAUFLFD, VKKAENDST, VKKAENDZL, VKKAENDBEN, VKKAENDDAT, VKKNEUBEN, VKKNEUDAT, VKKAESTAT, VKKAUFART, VKKKUNDNR, VKKVB, VKKVG, VKKADRSL, VKKVERBNR, VKKZENTR, VKKZENTRR, VKKKREDKDNR, VKKKDARTBEZ, VKKORDER, VKKANSPRECH, VKKANSPZUS, VKKBESTNR, VKKBESTDAT, VKKGLTVON, VKKGLTBIS, VKKETAB, VKKBESTSB, VKKAEDAT, VKKSACHBE, VKKPRGRP, VKKPRGRPV, VKKPRGRPZ, VKKPRGRPSTD, VKKPROJNR, VKKVKART, VKKKUNDNRST, VKKABNGRPST, VKKGLOBAL, VKKKOMENGE, VKKEINGET, VKKOFFEN, VKKEINGETOV, VKKEINGETPO, VKKCORQTY, VKKLIMGWO, VKKMEEH, VKKMEEHGRP, VKKMEEHFKT, VKKKOMENGET1, VKKKOMENGET2, VKKKOMENGET3, VKKKOMENGET4, VKKEINTT1, VKKEINTT2, VKKEINTT3, VKKEINTT4, VKKOFFENT1, VKKOFFENT2, VKKOFFENT3, VKKOFFENT4, VKKEINTTOV1, VKKEINTTOV2, VKKEINTTOV3, VKKEINTTOV4, VKKEINTTPO1, VKKEINTTPO2, VKKEINTTPO3, VKKEINTTPO4, VKKCORQTYT1, VKKCORQTYT2, VKKCORQTYT3, VKKCORQTYT4, VKKLIMGWOT1, VKKLIMGWOT2, VKKLIMGWOT3, VKKLIMGWOT4, VKKRSTBEZ, VKKOPTION, VKKOPTANBIS, VKKOPTANAM, VKKDECKPROZ, VKKWDECKDAT, VKKUEBEINT, VKKMINBEST, VKKMAXBEST, VKKSCHRAST, VKKGESMENGE1, VKKGESMENGE2, VKKGESMENGE3, VKKGESMENGE4, VKKGESWERT, VKKCOVPRC, VKKAKKREDNR, VKKGESSTA, VKKKDSTA, VKKAUFSTA, VKKPOSSTA, VKKSTA4, VKKKURS, VKKBETRAG, VKKVKURS, VKKVBETRAG, VKKSCHWPLU, VKKSCHWMIN, VKKHWAEHRSL, VKKHEUROKURS, VKKHEUROKURSVK, VKKFEUROKURS, VKKFEUROKURSVK, VKKALTWAEHR, VKKALTWAEHRF, VKKVALUTA, VKKVALDAT, VKKWAEHRSL, VKKZAHLBED, VKKEKON, VKKKDVKL, VKKLIEFBED, VKKLANDU, VKKPLZU, VKKORTU, VKKBZU, VKKBZBEZU, VKKCOUNTYU, VKKCITYU, VKKLIEFKOMP, VKKVERSART, VKKSPED, VKKZUSATZ, VKKDRBEST, VKKBSTDAT, VKKANGETEXT, VKKANGEWIE, VKKBESTTEXT, VKKBESTWIE, VKKLIEFTEXT, VKKLIEFWIE, VKKRECHTEXT, VKKRECHWIE, VKKLVORTEXT, VKKLVORWIE, VKKIVVTTEXT, VKKIVVTWIE, VKKIVDITEXT, VKKIVDIWIE, VKKAGT, VKKANGEALLG, VKKBESTALLG, VKKLIEFALLG, VKKRECHALLG, VKKLVORALLG, VKKIVVTALLG, VKKIVDIALLG, VKKANL1TXT, VKKANL2TXT, VKKANL3TXT, VKKDBLATT, VKKTBRIEF, VKKARTBILD, VKKFORMAT, VKKZEUGNIS, VKKRES1, VKKRES2, VKKVKZUABVH, VKKVKZUADR, VKKKZPRNEU, VKKKZFRNEU, VKKVAEAKZ, VKKMUKRS, VKKMULFD, VKKMUPOS, VKKCPKRS, VKKCPLFD, VKKCPPOS, VKKEDIKZ, VKKKOMMNR, VKKEDIDAT, VKKEDIZEIT, VKKABSAUFART, VKKARCHKZ, VKKARCHDAT, VKKARCHBEL, VKKOPITEM, VKKABSCHR, VKKSFEUCHTE, VKKAFEUCHTE, VKKFEUKZ, VKKABRKZ, VKKVTYP, VKKEXMANDANT, VKKWEGBINICH, VKKOFFNEU, VKKINDEXNA1, VKKINDEXBA1, VKKINDEXHS1, VKKINDEXNA2, VKKINDEXBA2, VKKINDEXHS2, VKKINDEXNA3, VKKINDEXBA3, VKKINDEXHS3, VKKHUELBE, VKKRATIFI, VKKMU1ANZ, VKKMU1GR, VKKMU1ME, VKKMU1PROMG, VKKMU2ANZ, VKKMU2GR, VKKMU2ME, VKKMU2PROMG, VKKFILLER)"
                        + " VALUES (:VKKMANDANT, '  ', :VKKAUFKRS, :VKKAUFLFD, '000', '012', 'SUNLV   ', 20130219, 'SUNLV   ', 20130104, 'S', 'NA', '00000200', 'RMB', '   ', '        ', '        ', '        ', ' ', '00000200', 'K', 'MAIL', '        ', '                          ', '               ', 20130219, 0, 0, 0, '              ', 20100224, 'BDE     ', 'SA      ', '        ', '        ', 'SA      ', '00000', '   ', '        ', '   ', ' ', 0, 0, 0, 0, 0, 0, 0, '   ', ' ', '000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', 0, 0, 1000, ' ', 0, 0, 0, ' ', 6, 303, 486, 84, 3896, 0, '                    ', '  ', '10', '20', '30', '40', '0010000', '0001', '0000000', '0000', 0, 0, 'RMB', 0, ' ', 0, ' ', '   ', 0, '000', 0, 'RMB', '30V', '        ', '   ', 'EXW', 'CN ', '42116       ', 'ZHANGJIAGANG                            ', '1 ', 'JIANGSU      ', '    ', '    ', 'N', 'LDY', 'HWD', '                                                            ', 'J', 0, ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', '        ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'N', 'N', 'J', '  ', '000000', '000', '  ', '000000', '000', ' ', '                    ', 0, 0, '  ', ' ', '00000000', '00000000', 'C0100227  ', '0000', '0000', '0000', ' ', ' ', ' ', '  ', ' ', '00000000', '      ', 0, 0, '      ', 0, 0, '      ', 0, 0, ' ', ' ', 0, 0, ' ', 0, 0, 0, ' ', 0, '                                                              ')";
                    break;
                case "50.25":
            or1.CommandText = "INSERT INTO VKKOPF(VKKMANDANT, VKKSA, VKKAUFKRS, VKKAUFLFD, VKKAENDST, VKKAENDZL, VKKAENDBEN, VKKAENDDAT, VKKNEUBEN, VKKNEUDAT, VKKAESTAT, VKKAUFART, VKKKUNDNR, VKKVB, VKKVG, VKKADRSL, VKKVERBNR, VKKZENTR, VKKZENTRR, VKKKREDKDNR, VKKKDARTBEZ, VKKORDER, VKKANSPRECH, VKKANSPZUS, VKKBESTNR, VKKBESTDAT, VKKGLTVON, VKKGLTBIS, VKKETAB, VKKBESTSB, VKKAEDAT, VKKSACHBE, VKKPRGRP, VKKPRGRPV, VKKPRGRPZ, VKKPRGRPSTD, VKKPROJNR, VKKVKART, VKKKUNDNRST, VKKABNGRPST, VKKGLOBAL, VKKKOMENGE, VKKEINGET, VKKOFFEN, VKKEINGETOV, VKKEINGETPO, VKKCORQTY, VKKLIMGWO, VKKMEEH, VKKMEEHGRP, VKKMEEHFKT, VKKKOMENGET1, VKKKOMENGET2, VKKKOMENGET3, VKKKOMENGET4, VKKEINTT1, VKKEINTT2, VKKEINTT3, VKKEINTT4, VKKOFFENT1, VKKOFFENT2, VKKOFFENT3, VKKOFFENT4, VKKEINTTOV1, VKKEINTTOV2, VKKEINTTOV3, VKKEINTTOV4, VKKEINTTPO1, VKKEINTTPO2, VKKEINTTPO3, VKKEINTTPO4, VKKCORQTYT1, VKKCORQTYT2, VKKCORQTYT3, VKKCORQTYT4, VKKLIMGWOT1, VKKLIMGWOT2, VKKLIMGWOT3, VKKLIMGWOT4, VKKRSTBEZ, VKKOPTION, VKKOPTANBIS, VKKOPTANAM, VKKDECKPROZ, VKKWDECKDAT, VKKUEBEINT, VKKMINBEST, VKKMAXBEST, VKKSCHRAST, VKKGESMENGE1, VKKGESMENGE2, VKKGESMENGE3, VKKGESMENGE4, VKKGESWERT, VKKCOVPRC, VKKAKKREDNR, VKKGESSTA, VKKKDSTA, VKKAUFSTA, VKKPOSSTA, VKKSTA4, VKKKURS, VKKBETRAG, VKKVKURS, VKKVBETRAG, VKKSCHWPLU, VKKSCHWMIN, VKKHWAEHRSL, VKKHEUROKURS, VKKHEUROKURSVK, VKKFEUROKURS, VKKFEUROKURSVK, VKKALTWAEHR, VKKALTWAEHRF, VKKVALUTA, VKKVALDAT, VKKWAEHRSL, VKKZAHLBED, VKKEKON, VKKKDVKL, VKKLIEFBED, VKKLANDU, VKKPLZU, VKKORTU, VKKBZU, VKKBZBEZU, VKKCOUNTYU, VKKCITYU, VKKLIEFKOMP, VKKVERSART, VKKSPED, VKKZUSATZ, VKKDRBEST, VKKBSTDAT, VKKANGETEXT, VKKANGEWIE, VKKBESTTEXT, VKKBESTWIE, VKKLIEFTEXT, VKKLIEFWIE, VKKRECHTEXT, VKKRECHWIE, VKKLVORTEXT, VKKLVORWIE, VKKIVVTTEXT, VKKIVVTWIE, VKKIVDITEXT, VKKIVDIWIE, VKKAGT, VKKANGEALLG, VKKBESTALLG, VKKLIEFALLG, VKKRECHALLG, VKKLVORALLG, VKKIVVTALLG, VKKIVDIALLG, VKKANL1TXT, VKKANL2TXT, VKKANL3TXT, VKKDBLATT, VKKTBRIEF, VKKARTBILD, VKKFORMAT, VKKZEUGNIS, VKKRES1, VKKRES2, VKKVKZUABVH, VKKVKZUADR, VKKKZPRNEU, VKKKZFRNEU, VKKVAEAKZ, VKKMUKRS, VKKMULFD, VKKMUPOS, VKKCPKRS, VKKCPLFD, VKKCPPOS, VKKEDIKZ, VKKKOMMNR, VKKEDIDAT, VKKEDIZEIT, VKKABSAUFART, VKKARCHKZ, VKKARCHDAT, VKKARCHBEL, VKKOPITEM, VKKABSCHR, VKKSFEUCHTE, VKKAFEUCHTE, VKKFEUKZ, VKKABRKZ, VKKVTYP, VKKEXMANDANT, VKKWEGBINICH, VKKOFFNEU, VKKINDEXNA1, VKKINDEXBA1, VKKINDEXHS1, VKKINDEXNA2, VKKINDEXBA2, VKKINDEXHS2, VKKINDEXNA3, VKKINDEXBA3, VKKINDEXHS3, VKKHUELBE, VKKRATIFI, VKKMU1ANZ, VKKMU1GR, VKKMU1ME, VKKMU1PROMG, VKKMU2ANZ, VKKMU2GR, VKKMU2ME, VKKMU2PROMG, VKKSPARTE, VKKEINSATZG, VKKVERWEND, VKKERL, VKKFILLER)"
                + " VALUES (:VKKMANDANT, '  ', :VKKAUFKRS, :VKKAUFLFD, '000', '012', 'SUNLV   ', 20130219, 'SUNLV   ', 20130104, 'S', 'NA', '00000200', 'RMB', '   ', '        ', '        ', '        ', ' ', '00000200', 'K', 'MAIL', '        ', '                          ', '               ', 20130219, 0, 0, 0, '              ', 20100224, 'BDE     ', 'SA      ', '        ', '        ', 'SA      ', '00000', '   ', '        ', '   ', ' ', 0, 0, 0, 0, 0, 0, 0, '   ', ' ', '000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', 0, 0, 1000, ' ', 0, 0, 0, ' ', 6, 303, 486, 84, 3896, 0, '                    ', '  ', '10', '20', '30', '40', '0010000', '0001', '0000000', '0000', 0, 0, 'RMB', 0, ' ', 0, ' ', '   ', 0, '000', 0, 'RMB', '30V', '        ', '   ', 'EXW', 'CN ', '42116       ', 'ZHANGJIAGANG                            ', '1 ', 'JIANGSU      ', '    ', '    ', 'N', 'LDY', 'HWD', '                                                            ', 'J', 0, ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', '        ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'N', 'N', 'J', '  ', '000000', '000', '  ', '000000', '000', ' ', '                    ', 0, 0, '  ', ' ', '00000000', '00000000', 'C0100227  ', '0000', '0000', '0000', ' ', ' ', ' ', '  ', ' ', '00000000', '      ', 0, 0, '      ', 0, 0, '      ', 0, 0, ' ', ' ', 0, 0, '   ', 0, 0, 0, '   ', 0, '  ', '    ', '    ', ' ', '                                               ')";
                    break;
                default:
                    break;
            }
            or1.Parameters.Add("VKKMANDANT", OracleType.NVarChar).Value = dwData["VKKMANDANT"].ToString();
            or1.Parameters.Add("VKKAUFKRS", OracleType.NVarChar).Value = dwData["VKKAUFKRS"].ToString();
            or1.Parameters.Add("VKKAUFLFD", OracleType.NVarChar).Value = dwData["VKKAUFLFD"].ToString();
            Connect2Proxy(or1); 
        }
        public void InsertVKPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            or1 = OracleDB.CreateCommand();
            DataSet result = new DataSet();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    or1.CommandText = "INSERT INTO VKPOS(VKPMANDANT, VKPSA, VKPAUFKRS, VKPAUFLFD, VKPAUFPOS, VKPAENDST, VKPAENDZL, VKPAENDBEN, VKPAENDDAT, VKPNEUBEN, VKPNEUDAT, VKPPAENDDAT, VKPPAENPROG, VKPAESTAT, VKPVB, VKPVG, VKPKUNDNR, VKPAUFART, VKPSACHBE, VKPPOSTYP, VKPABWERT, VKPMUSTER, VKPABVK, VKPEIL, VKPEZEIT, VKPERL, VKPPRODST, VKPARTST, VKPKOLL, VKPART, VKPFARBE, VKPGROE, VKPZENSUR, VKPAUFMART, VKPVERPART, VKPKURZBEZ, VKPKKOLL, VKPKDARTNR, VKPKDBEZ, VKPKDFARBNR, VKPPRGR, VKPARTGRP, VKPDSACHB, VKPZIELGR, VKPMENGE1, VKPMENGE2, VKPRESERV, VKPZUGET, VKPFREIGE, VKPGAUFBEST, VKPKOMMISS, VKPFAKT, VKPVERS, VKPEINGET, VKPOFFEN, VKPMEEH, VKPMEEHGRP, VKPMEEHFKT, VKPMENGE1T1, VKPMENGE1T2, VKPMENGE1T3, VKPMENGE1T4, VKPRESERVT1, VKPRESERVT2, VKPRESERVT3, VKPRESERVT4, VKPZUGETT1, VKPZUGETT2, VKPZUGETT3, VKPZUGETT4, VKPFREIGET1, VKPFREIGET2, VKPFREIGET3, VKPFREIGET4, VKPGAUFBESTT1, VKPGAUFBESTT2, VKPGAUFBESTT3, VKPGAUFBESTT4, VKPKOMMIST1, VKPKOMMIST2, VKPKOMMIST3, VKPKOMMIST4, VKPFAKTT1, VKPFAKTT2, VKPFAKTT3, VKPFAKTT4, VKPVERST1, VKPVERST2, VKPVERST3, VKPVERST4, VKPEINTT1, VKPEINTT2, VKPEINTT3, VKPEINTT4, VKPOFFENT1, VKPOFFENT2, VKPOFFENT3, VKPOFFENT4, VKPWVTERM, VKPWUTERM, VKPFREITERM, VKPVERSTERM, VKPLIEFTERM, VKPLIEFEING, VKPEINTTERM, VKPEINTEING, VKPVERZEING1, VKPVERZTERM1, VKPBESTTERM1, VKPVERZEING2, VKPVERZTERM2, VKPBESTTERM2, VKPVERZEING3, VKPVERZTERM3, VKPBESTTERM3, VKPVERZEING4, VKPVERZTERM4, VKPBESTTERM4, VKPVERZEING5, VKPVERZTERM5, VKPBESTTERM5, VKPLVDAT, VKPEINTVON, VKPVALUTA, VKPVALDAT, VKPLIEFZEIT, VKPLZEIT, VKPSTORDAT, VKPNACHL, VKPVERTKZ, VKPVKNPOS, VKPLTERMIN1, VKPLTART1, VKPMENGEP1, VKPLTERMIN2, VKPLTART2, VKPMENGEP2, VKPLTERMIN3, VKPLTART3, VKPMENGEP3, VKPLTERMIN4, VKPLTART4, VKPMENGEP4, VKPLTERMIN5, VKPLTART5, VKPMENGEP5, VKPSHOE, VKPSLAE, VKPOPTRLAE, VKPOPTART, VKPSPUL, VKPSPULG, VKPSPULGV, VKPSPULGB, VKPSPULM, VKPSPULMV, VKPSPULMB, VKPSPUL2, VKPSPULG2, VKPHUELSE, VKPKF, VKPFDRES, VKPWI, VKPSCHLICHTGR, VKPSCHLICHTNR, VKPHABR, VKPVABR, VKPSETKZ, VKPPRGRP, VKPLFDNR, VKPARTPRGR, VKPCOUPON, VKPPREIS, VKPPREH, VKPPREHGRP, VKPPREHFKT, VKPPRKZ, VKPPREISPRF, VKPUGSACHB, VKPPRLPREIS, VKPPREISUG, VKPKONFEKT, VKPPOSWERT, VKPSTAFFELF, VKPVGUET, VKPSONDERP, VKPINDEXNA1, VKPINDEXBA1, VKPINDEXWE1, VKPINDEXHS1, VKPINDEXNA2, VKPINDEXBA2, VKPINDEXWE2, VKPINDEXHS2, VKPINDEXNA3, VKPINDEXBA3, VKPINDEXWE3, VKPINDEXHS3, VKPKOAUFKRS, VKPKOAUFLFD, VKPKOAUFPOS, VKPKOAUFART, VKPARTPRF, VKPKZFREI, VKPFARBGRP, VKPARTUG, VKPFARBEUG, VKPARTOG, VKPFARBEOG, VKPIAEDAT, VKPEMENGEV, VKPEMENGEB, VKPPMENGE, VKPVERTEIL, VKPWDECK, VKPKANR, VKPKAPOS, VKPABLGRD, VKPGELISTET, VKPKONKURENT, VKPKPREIS, VKPHOCHRECH, VKPERFOLG, VKPANT, VKPANTSAV, VKPSIGNED, VKPABS, VKPABRKZ, VKPNOCOUNT, VKPEXAUFKRS, VKPEXAUFLFD, VKPEXAUFPOS, VKPEXART, VKPEXVAR, VKPEXDESS, VKPEXCOLORIT, VKPRAPLG, VKPRAPWDT, VKPGESSTA, VKPARTSTA, VKPPRSTA, VKPBSTSTA, VKPTERMSTA, VKPMGV, VKPMGB, VKPMGZU, VKPSTV, VKPSTB, VKPSTZU, VKPSTLGV, VKPSTLGB, VKPPAS, VKPPAI, VKPTSTS, VKPTSTI, VKPTSTLG, VKPTSTMAX, VKPUBLI, VKPAZUTEIL, VKPERSART, VKPZUTART, VKPZSBER, VKPFA, VKPGA, VKPQA, VKPMAART, VKPMAFZST, VKPZUSAM, VKPZUDOPA, VKPZUDPA, VKPGENEHM, VKPMUVERT, VKPZRUECK, VKPZKDAT, VKPZKBEN, VKPSTKNEUTR, VKPPARTGL, VKPKONFKZ, VKPKETTELN, VKPRESSACHB, VKPLAEVON, VKPLAEBIS, VKPSTDLAE, VKPSFERTKZ, VKPREGEL, VKPZUTPRIO, VKPSTAFFNR, VKPMAXPKT, VKPANZ1, VKPLAENGE1, VKPBREITE1, VKPANZ2, VKPLAENGE2, VKPBREITE2, VKPANZ3, VKPLAENGE3, VKPBREITE3, VKPANZ4, VKPLAENGE4, VKPBREITE4, VKPANZ5, VKPLAENGE5, VKPBREITE5, VKPFIXMASS, VKPURLAND, VKPPRFBEG, VKPPRFVKD, VKPEINWERK, VKPWERK, VKPQPKTH, VKPQPKTLH, VKPRICHGL, VKPWSCHTXT, VKPFILLER1, VKPABRUF, VKPLIEFKOMP, VKPVERSART, VKPZUSATZ, VKPKDKOMM, VKPLTEILNR, VKPVERSLO, VKPAUTOFREI, VKPSTRECKE, VKPANGETEXT, VKPANGEWIE, VKPBESTTEXT, VKPBESTWIE, VKPLIEFTEXT, VKPLIEFWIE, VKPRECHTEXT, VKPRECHWIE, VKPLVORTEXT, VKPLVORWIE, VKPIVVTTEXT, VKPIVVTWIE, VKPIVDITEXT, VKPIVDIWIE, VKPARTTEXT, VKPANGEALLG, VKPBESTALLG, VKPLIEFALLG, VKPRECHALLG, VKPLVORALLG, VKPIVVTALLG, VKPIVDIALLG, VKPANL1TXT, VKPANL2TXT, VKPANL3TXT, VKPAGT, VKPAUF1, VKPAUF2, VKPAUF3, VKPDISPO, VKPDDBENID, VKPDDAUFTNR, VKPEKOLL, VKPEART, VKPEFARBE, VKPLVERD, VKPWOBST, VKPEAKZ, VKPWAEHRSL, VKPKURS, VKPBETRAG, VKPHWAEHRSL, VKPHEUROKURS, VKPHEUROKURSVK, VKPFEUROKURS, VKPFEUROKURSVK, VKPTERMNR, VKPFAELLIG, VKPSICHER, VKPSICHP, VKPAKKRED, VKPBESTPOS, VKPDBLATT, VKPTBRIEF, VKPARTBILD, VKPFORMAT, VKPZEUGNIS, VKPPLANKRS, VKPPLANLFD, VKPRES1, VKPRES2, VKPVKZUABVH, VKPVKZUSAMP, VKPVKZUADR, VKPFKSPKZ, VKPFKSPRD, VKPFKSPTD, VKPKREDLIM, VKPSWING, VKPRAITING, VKPVERSCHL, VKPKREDBIS, VKPKREDVON, VKPLUEBKZ, VKPFRDAT, VKPFRZEIT, VKPFRBENID, VKPFRKZ, VKPCUSIGNED, VKPSTPROV, VKPSTFRACHT, VKPSTFRME, VKPSTIMP, VKPSTVERS, VKPSTZOLL, VKPFRGRENZ, VKPFRGRME, VKPVERSGRENZ, VKPZTARIF, VKPEDIKZ, VKPKOMMNR, VKPKOMMPOS, VKPEDIDAT, VKPEDIZEIT, VKPURBESTPOS, VKPVERTRNRK, VKPVERTRPOSK, VKPOPREIS, VKPOMENGE, VKPWUTERMKO, VKPKZERSATZ, VKPBUSIMODE, VKPEXMANDANT, VKPRUECKTG, VKPLIEFTERMN, VKPVERARBSTA, VKPCTO, VKPVTRNRK2, VKPVTRPOSK2, VKPAENTIME, VKPMAINPROG, VKPSAMPTYP, VKPUSRSTA, VKPACCVERS, VKPLIART, VKPDELTAE, VKPLIART2, VKPDELTAE2, VKPLIART3, VKPDELTAE3, VKPLINKMARK, VKPFILLER2)"
                        + " VALUES (:VKPMANDANT, '  ', :VKPAUFKRS, :VKPAUFLFD, :VKPAUFPOS, '00000000', 3, '        ', 0, 'SUNLV   ', 20130104, 0, '        ', 'S', 'RMB', '   ', '00000200', 'NA', 'BDE     ', '   ', 0, ' ', ' ', ' ', 2151, ' ', 'M', 'F', 'HLT10', 'PV912102                ', 'RD01      ', '       ', '1', '  ', '   ', '????è?μó32', '     ', '                        ', '                              ', '          ', 'HLT', 'WOV', 'SUNLE   ', '    ', 12300, 0, 0, 134, 134, 0, 134, 0, 0, 0, 12300, 'MTR', '2', '000001000000', 200, 12300, 19717, 3444, 0, 0, 0, 0, 100, 134, 211, 52, 100, 134, 212, 53, 0, 0, 0, 0, 100, 134, 212, 53, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 12300, 19717, 3444, 0, 20130104, 20130104, 20130104, 20130104, '4.1.13  ', 0, '        ', '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, 0, 0, 0, 0, '                                        ', 0, 0, 0, ' ', '000', 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', ' ', ' ', '     ', '               ', ' ', ' ', ' ', '        ', '000', '   ', ' ', '0000012000', 'MTR', '2', '000001000000', '  ', ' ', '        ', '0000000000', 0, 0, 1476, ' ', ' ', ' ', '      ', 0, 0, 0, '      ', 0, 0, 0, '      ', 0, 0, 0, '  ', '000000', '000', '  ', ' ', ' ', ' ', 'PV912102                ', 'RD01      ', 'PV912102                ', 'RD01      ', 79899775, 0, 0, 0, ' ', ' ', '00000000', '0000', '  ', ' ', '        ', '0000000000', ' ', 0, 0, 0, ' ', 0, ' ', ' ', '  ', '000000', '000', '                    ', '   ', '          ', '          ', 0, 0, '  ', '50', '60', '70', '80', 12300, 12300, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, ' ', ' ', ' ', ' ', ' ', 0, 0, 0, ' ', 0, '  ', '           ', ' ', ' ', '    ', 'J', 0, '        ', ' ', '000', ' ', ' ', '        ', 10000, 12000, 12000, ' ', '00000000', ' ', '00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', '   ', ' ', ' ', ' ', ' ', 0, 0, 'J', '   ', '                              ', ' ', ' ', '   ', '                              ', '100227XYZ      ', '0001', '01', ' ', ' ', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '          ', ' ', ' ', ' ', ' ', '        ', '0000', '     ', '                        ', '          ', ' ', ' ', ' ', 'RMB', 10000, 1, 'RMB', 0, ' ', 0, ' ', 0, 20130104, ' ', 0, '               ', '000', ' ', ' ', ' ', ' ', ' ', '  ', '000000', ' ', ' ', ' ', ' ', ' ', ' ', 0, 0, '0090000000', '0089728588', '003', '01', 20231212, 0, ' ', 20130105, 2018, 'INTEXE  ', ' ', ' ', 0, 0, '   ', 0, 0, 0, 0, '   ', 0, '                    ', ' ', '                    ', '0000', 0, 0, '000', '                    ', '0000', '0000000000', 0, 0, ' ', '   ', '  ', 0, 0, '90', ' ', '                    ', 0, 0, '        ', '   ', '  ', '   ', '     ', 0, '     ', 0, '     ', 0, ' ', '                                      ')";
                    break;
                case "50.25":
                    or1.CommandText = " INSERT INTO VKPOS(VKPMANDANT, VKPSA, VKPAUFKRS, VKPAUFLFD, VKPAUFPOS, VKPAENDST, VKPAENDZL, VKPAENDBEN, VKPAENDDAT, VKPNEUBEN, VKPNEUDAT, VKPPAENDDAT, VKPPAENPROG, VKPAESTAT, VKPVB, VKPVG, VKPKUNDNR, VKPAUFART, VKPSACHBE, VKPPOSTYP, VKPABWERT, VKPMUSTER, VKPABVK, VKPEIL, VKPEZEIT, VKPERL, VKPERLDAT, VKPERLBEN, VKPPRODST, VKPARTST, VKPKOLL, VKPART, VKPFARBE, VKPGROE, VKPZENSUR, VKPAUFMART, VKPVERPART, VKPKURZBEZ, VKPKKOLL, VKPKDARTNR, VKPKDBEZ, VKPKDFARBNR, VKPPRGR, VKPARTGRP, VKPDSACHB, VKPZIELGR, VKPMENGE1, VKPMENGE2, VKPRESERV, VKPZUGET, VKPFREIGE, VKPGAUFBEST, VKPKOMMISS, VKPFAKT, VKPVERS, VKPEINGET, VKPOFFEN, VKPMEEH, VKPMEEHGRP, VKPMEEHFKT, VKPMENGE1T1, VKPMENGE1T2, VKPMENGE1T3, VKPMENGE1T4, VKPRESERVT1, VKPRESERVT2, VKPRESERVT3, VKPRESERVT4, VKPZUGETT1, VKPZUGETT2, VKPZUGETT3, VKPZUGETT4, VKPFREIGET1, VKPFREIGET2, VKPFREIGET3, VKPFREIGET4, VKPGAUFBESTT1, VKPGAUFBESTT2, VKPGAUFBESTT3, VKPGAUFBESTT4, VKPKOMMIST1, VKPKOMMIST2, VKPKOMMIST3, VKPKOMMIST4, VKPFAKTT1, VKPFAKTT2, VKPFAKTT3, VKPFAKTT4, VKPVERST1, VKPVERST2, VKPVERST3, VKPVERST4, VKPEINTT1, VKPEINTT2, VKPEINTT3, VKPEINTT4, VKPOFFENT1, VKPOFFENT2, VKPOFFENT3, VKPOFFENT4, VKPWVTERM, VKPWUTERM, VKPFREITERM, VKPVERSTERM, VKPLIEFTERM, VKPLIEFEING, VKPEINTTERM, VKPEINTEING, VKPVERZEING1, VKPVERZTERM1, VKPBESTTERM1, VKPVERZEING2, VKPVERZTERM2, VKPBESTTERM2, VKPVERZEING3, VKPVERZTERM3, VKPBESTTERM3, VKPVERZEING4, VKPVERZTERM4, VKPBESTTERM4, VKPVERZEING5, VKPVERZTERM5, VKPBESTTERM5, VKPLVDAT, VKPEINTVON, VKPVALUTA, VKPVALDAT, VKPLIEFZEIT, VKPLZEIT, VKPSTORDAT, VKPNACHL, VKPVERTKZ, VKPVKNPOS, VKPLTERMIN1, VKPLTART1, VKPMENGEP1, VKPLTERMIN2, VKPLTART2, VKPMENGEP2, VKPLTERMIN3, VKPLTART3, VKPMENGEP3, VKPLTERMIN4, VKPLTART4, VKPMENGEP4, VKPLTERMIN5, VKPLTART5, VKPMENGEP5, VKPSHOE, VKPSLAE, VKPOPTRLAE, VKPOPTART, VKPSPUL, VKPSPULG, VKPSPULGV, VKPSPULGB, VKPSPULM, VKPSPULMV, VKPSPULMB, VKPSPUL2, VKPSPULG2, VKPHUELSE, VKPKF, VKPFDRES, VKPWI, VKPSCHLICHTGR, VKPSCHLICHTNR, VKPHABR, VKPVABR, VKPSETKZ, VKPPRGRP, VKPLFDNR, VKPARTPRGR, VKPCOUPON, VKPPREIS, VKPPREH, VKPPREHGRP, VKPPREHFKT, VKPPRKZ, VKPPREISPRF, VKPUGSACHB, VKPPRLPREIS, VKPPREISUG, VKPKONFEKT, VKPPOSWERT, VKPSTAFFELF, VKPVGUET, VKPSONDERP, VKPINDEXNA1, VKPINDEXBA1, VKPINDEXWE1, VKPINDEXHS1, VKPINDEXNA2, VKPINDEXBA2, VKPINDEXWE2, VKPINDEXHS2, VKPINDEXNA3, VKPINDEXBA3, VKPINDEXWE3, VKPINDEXHS3, VKPKOAUFKRS, VKPKOAUFLFD, VKPKOAUFPOS, VKPKOAUFART, VKPARTPRF, VKPKZFREI, VKPFARBGRP, VKPARTUG, VKPFARBEUG, VKPARTOG, VKPFARBEOG, VKPIAEDAT, VKPEMENGEV, VKPEMENGEB, VKPPMENGE, VKPVERTEIL, VKPWDECK, VKPKANR, VKPKAPOS, VKPABLGRD, VKPGELISTET, VKPKONKURENT, VKPKPREIS, VKPHOCHRECH, VKPERFOLG, VKPANT, VKPANTSAV, VKPSIGNED, VKPABS, VKPABRKZ, VKPNOCOUNT, VKPEXAUFKRS, VKPEXAUFLFD, VKPEXAUFPOS, VKPEXART, VKPEXVAR, VKPEXDESS, VKPEXCOLORIT, VKPRAPLG, VKPRAPWDT, VKPGESSTA, VKPARTSTA, VKPPRSTA, VKPBSTSTA, VKPTERMSTA, VKPMGV, VKPMGB, VKPMGZU, VKPSTV, VKPSTB, VKPSTZU, VKPSTLGV, VKPSTLGB, VKPPAS, VKPPAI, VKPTSTS, VKPTSTI, VKPTSTLG, VKPTSTMAX, VKPUBLI, VKPAZUTEIL, VKPERSART, VKPZUTART, VKPZSBER, VKPFA, VKPGA, VKPQA, VKPMAART, VKPMAFZST, VKPZUSAM, VKPZUDOPA, VKPZUDPA, VKPGENEHM, VKPMUVERT, VKPZRUECK, VKPZKDAT, VKPZKBEN, VKPSTKNEUTR, VKPPARTGL, VKPKONFKZ, VKPKETTELN, VKPRESSACHB, VKPLAEVON, VKPLAEBIS, VKPSTDLAE, VKPSFERTKZ, VKPREGEL, VKPZUTPRIO, VKPSTAFFNR, VKPMAXPKT, VKPANZ1, VKPLAENGE1, VKPBREITE1, VKPANZ2, VKPLAENGE2, VKPBREITE2, VKPANZ3, VKPLAENGE3, VKPBREITE3, VKPANZ4, VKPLAENGE4, VKPBREITE4, VKPANZ5, VKPLAENGE5, VKPBREITE5, VKPFIXMASS, VKPURLAND, VKPPRFBEG, VKPPRFVKD, VKPEINWERK, VKPWERK, VKPQPKTH, VKPQPKTLH, VKPRICHGL, VKPWSCHTXT, VKPFILLER1, VKPABRUF, VKPLIEFKOMP, VKPVERSART, VKPZUSATZ, VKPKDKOMM, VKPLTEILNR, VKPVERSLO, VKPAUTOFREI, VKPSTRECKE, VKPANGETEXT, VKPANGEWIE, VKPBESTTEXT, VKPBESTWIE, VKPLIEFTEXT, VKPLIEFWIE, VKPRECHTEXT, VKPRECHWIE, VKPLVORTEXT, VKPLVORWIE, VKPIVVTTEXT, VKPIVVTWIE, VKPIVDITEXT, VKPIVDIWIE, VKPARTTEXT, VKPANGEALLG, VKPBESTALLG, VKPLIEFALLG, VKPRECHALLG, VKPLVORALLG, VKPIVVTALLG, VKPIVDIALLG, VKPANL1TXT, VKPANL2TXT, VKPANL3TXT, VKPAGT, VKPAUF1, VKPAUF2, VKPAUF3, VKPDISPO, VKPDDBENID, VKPDDAUFTNR, VKPEKOLL, VKPEART, VKPEFARBE, VKPLVERD, VKPWOBST, VKPEAKZ, VKPWAEHRSL, VKPKURS, VKPBETRAG, VKPHWAEHRSL, VKPHEUROKURS, VKPHEUROKURSVK, VKPFEUROKURS, VKPFEUROKURSVK, VKPTERMNR, VKPFAELLIG, VKPSICHER, VKPSICHP, VKPAKKRED, VKPBESTPOS, VKPDBLATT, VKPTBRIEF, VKPARTBILD, VKPFORMAT, VKPZEUGNIS, VKPPLANKRS, VKPPLANLFD, VKPRES1, VKPRES2, VKPVKZUABVH, VKPVKZUSAMP, VKPVKZUADR, VKPFKSPKZ, VKPFKSPRD, VKPFKSPTD, VKPKREDLIM, VKPSWING, VKPRAITING, VKPVERSCHL, VKPKREDBIS, VKPKREDVON, VKPLUEBKZ, VKPFRDAT, VKPFRZEIT, VKPFRBENID, VKPFRKZ, VKPCUSIGNED, VKPSTPROV, VKPSTFRACHT, VKPSTFRME, VKPSTIMP, VKPSTVERS, VKPSTZOLL, VKPFRGRENZ, VKPFRGRME, VKPVERSGRENZ, VKPZTARIF, VKPEDIKZ, VKPKOMMNR, VKPKOMMPOS, VKPEDIDAT, VKPEDIZEIT, VKPURBESTPOS, VKPVERTRNRK, VKPVERTRPOSK, VKPOPREIS, VKPOMENGE, VKPWUTERMKO, VKPKZERSATZ, VKPBUSIMODE, VKPEXMANDANT, VKPRUECKTG, VKPLIEFTERMN, VKPVERARBSTA, VKPCTO, VKPVTRNRK2, VKPVTRPOSK2, VKPAENTIME, VKPMAINPROG, VKPSAMPTYP, VKPUSRSTA, VKPACCVERS, VKPLIART, VKPDELTAE, VKPLIART2, VKPDELTAE2, VKPLIART3, VKPDELTAE3, VKPLINKMARK, VKPKREDNL, VKPEINSATZG, VKPVERWEND, VKPFILLER2)"
                      + " VALUES (:VKPMANDANT, '  ', :VKPAUFKRS, :VKPAUFLFD, :VKPAUFPOS, '00000000', 0, '        ', 0, 'SUNLV   ', 20130104, 0, '        ', 'S', 'RMB', '   ', '00000200', 'NA', 'BDE     ', '   ', 0, ' ', ' ', ' ', 2151, ' ', 0, '        ', 'M', 'F', 'HLT10', 'PV912102                ', 'RD01      ', '       ', '1', '  ', '   ', '??I?E<?O32', '     ', '                        ', '                              ', '          ', 'HLT', 'WOV', 'SUNLE   ', '    ', 12300, 0, 0, 134, 134, 0, 134, 0, 0, 0, 12300, 'MTR', '2', '000001000000', 200, 12300, 19717, 3444, 0, 0, 0, 0, 100, 134, 211, 52, 100, 134, 212, 53, 0, 0, 0, 0, 100, 134, 212, 53, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 12300, 19717, 3444, 0, 20130104, 20130104, 20130104, 20130104, '4.1.13  ', 0, '        ', '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, '        ', 0, 0, 0, 0, 0, 0, '                                        ', 0, 0, 0, ' ', '000', 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, ' ', 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', ' ', ' ', '     ', '               ', ' ', ' ', ' ', '        ', '000', '   ', ' ', '0000012000', 'MTR', '2', '000001000000', '  ', ' ', '        ', '0000000000', 0, 0, 1476, ' ', ' ', ' ', '      ', 0, 0, 0, '      ', 0, 0, 0, '      ', 0, 0, 0, '  ', '000000', '000', '  ', ' ', ' ', ' ', 'PV912102                ', 'RD01      ', 'PV912102                ', 'RD01      ', 79899775, 0, 0, 0, ' ', ' ', '00000000', '0000', '  ', ' ', '        ', '0000000000', ' ', 0, 0, 0, ' ', 0, ' ', ' ', '  ', '000000', '000', '                    ', '   ', '          ', '          ', 0, 0, '  ', '50', '60', '70', '80', 12300, 12300, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, ' ', ' ', ' ', ' ', ' ', 0, 0, 0, ' ', 0, '  ', '           ', ' ', ' ', '    ', 'J', 0, '        ', ' ', '000', ' ', ' ', '        ', 10000, 12000, 12000, ' ', '00000000', ' ', '00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', '   ', ' ', ' ', ' ', ' ', 0, 0, 'J', '   ', '                              ', ' ', ' ', '   ', '                              ', '100227XYZ      ', '0001', '01', ' ', ' ', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '          ', ' ', ' ', ' ', ' ', '        ', '0000', '     ', '                        ', '          ', ' ', ' ', ' ', 'RMB', 10000, 1, 'RMB', 0, ' ', 0, ' ', 0, 20130104, ' ', 0, '               ', '000', ' ', ' ', ' ', ' ', ' ', '  ', '000000', ' ', ' ', ' ', ' ', ' ', ' ', 0, 0, '0090000000', '0089728588', '003', '01', 20231212, 0, ' ', 20130105, 2018, 'INTEXE  ', ' ', ' ', 0, 0, '   ', 0, 0, 0, 0, '   ', 0, '                    ', ' ', '                    ', '0000', 0, 0, '000', '                    ', '0000', '0000000000', 0, 0, ' ', '   ', '  ', 0, 0, '90', ' ', '                    ', 0, 0, '        ', '   ', '  ', '   ', '     ', 0, '     ', 0, '     ', 0, ' ', ' ', '    ', '    ', '                                                                                                                 ')";
                    break;
                default:
                    break;
            }
            or1.Parameters.Add("VKPMANDANT", OracleType.NVarChar).Value = dwData["VKPMANDANT"].ToString();  
            or1.Parameters.Add("VKPAUFKRS", OracleType.NVarChar).Value = dwData["VKPAUFKRS"].ToString();
            or1.Parameters.Add("VKPAUFLFD", OracleType.NVarChar).Value = dwData["VKPAUFLFD"].ToString();
            or1.Parameters.Add("VKPAUFPOS", OracleType.NVarChar).Value = dwData["VKPAUFPOS"].ToString();
            Connect2Proxy(or1); 
        }
        //WDECK WBBST WBBEW VVLIEF VVTLIEF
        public void InsertVVLIEF(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    or1.CommandText = "INSERT INTO VVLIEF(VVMANDANT, VVLIEFSCH, VVLO, VVPRODST1, VVPRODST2, VVPRODST3, VVPRODST4, VVPRODST5, VVPRODST6, VVPRODST7, VVPRODST8, VVPRODST9, VVLIEFSCHTYP, VVKZINLEXP, VVSTATUS, VVVERSART, VVSPED, VVVERSARTU, VVSPEDU, VVVERSARTV, VVSPEDV, VVEBDAT, VVKZEBBUCH, VVLAND, VVPLZ, VVORT, VVBZ, VVBZBEZ, VVCOUNTY, VVCITY, VVAVISNR, VVFBR, VVLIEFBED, VVKZKOSTBER, VVLANDU, VVPLZU, VVORTU, VVBZU, VVBZBEZU, VVCOUNTYU, VVCITYU, VVLIEFSCHGRP, VVVERSDAT, VVLIEFDAT, VVFIXDAT, VVVERPART, VVGUETERNR, VVKZEINZEL, VVEINZTARA, VVEINZBRUT, VVEINZNET, VVANZ, VVTARA, VVBRUTTO, VVNETTO, VVVOLUMEN, VVANZSTK, VVNETMTR, VVWERT, VVLB1, VVANZPAL1, VVANZAPAL1, VVANZRPAL1, VVLB2, VVANZPAL2, VVANZAPAL2, VVANZRPAL2, VVLB3, VVANZPAL3, VVANZAPAL3, VVANZRPAL3, VVLB4, VVANZPAL4, VVANZAPAL4, VVANZRPAL4, VVLB5, VVANZPAL5, VVANZAPAL5, VVANZRPAL5, VVLB6, VVANZPAL6, VVANZAPAL6, VVANZRPAL6, VVKOLP, VVVPLP, VVTPSTA, VVTPMA1, VVTPMAANZ1, VVTPMA2, VVTPMAANZ2, VVGTBS, VVGTBK, VVKM1, VVGTBZ, VVKM2, VVTARIF1, VVORTKL1, VVFRPFL1, VVLAKL1, VVFRSATZ1, VVFRERRECH1, VVMARGEP1, VVMARGEA1, VVSUMME1, VVTARIF2, VVORTKL2, VVFRPFL2, VVLAKL2, VVFRSATZ2, VVFRERRECH2, VVMARGEP2, VVMARGEA2, VVSUMME2, VVTARIF3, VVORTKL3, VVFRPFL3, VVLAKL3, VVFRSATZ3, VVFRERRECH3, VVMARGEP3, VVMARGEA3, VVSUMME3, VVPRAEMIEV, VVPOLICE, VVGDATBIS, VVWERTV, VVWAEHRSLV, VVNEBENKO, VVWAEHRSLN, VVNACHNA, VVFESTBETR, VVVERZOLLT, VVKZABRFR, VVZAHLART, VVZAHLBED, VVKZLSPERR, VVANAME1, VVANAME2, VVASTRASSE, VVASTRASSE2, VVALAND, VVAPLZ, VVAORT, VVABZ, VVABZBEZ, VVACOUNTY, VVACITY, VVKUNDNRV, VVADRSLV, VVKUNDNRE, VVEMPFKZ, VVADRSLL, VVADRSLO, VVKUNDNRVF, VVADRSLKVF, VVADRSLLVF, VVKUNDNRR, VVADRSLKR, VVADRSLLR, VVKUNDNRF, VVADRSLKF, VVADRSLLF, VVANTEILF, VVPI, VVET, VVLS, VVPA, VVLA, VVFR, VVAV, VVDECKBLATT, VVLIEFSCHPOS, VVLPACKNR, VVANZTLIEF, VVANZTLIEFR, VVANZTLIEFB, VVLIEFTERM, VVFRACHTBE, VVVB, VVKZKUNDV, VVZONE, VVKGBIS, VVKDVKL, VVADRSLLUR, VVVALUTA, VVVALDAT, VVEKON, VVVERSIBE, VVVSTK, VVLSTKPA, VVPAUFKRS, VVPAUFLFD, VVPAUFPOS, VVVERPKOST, VVKOSTBGR, VVVERPKOSTE, VVLIEFNR, VVRENR, VVREPOS, VVREDAT, VVFRNETTO, VVFRKSTA, VVZOLLPAP, VVPROGRP, VVUEBKZ, VVDROFT, VVKREDLIM, VVSWING, VVRAITING, VVVERS, VVKREDBIS, VVKREDVON, VVLUEBKZ, VVFRDAT, VVFRZEIT, VVFRBENID, VVKUNDNRRE, VVLIEFART, VVKTRANSDAT, VVKTRANSUHR, VVKTRANSBEN, VVKTRANSSTA, VVSTRANSDATA, VVSTRANSUHRA, VVSTRANSERL, VVSTRANSDATE, VVSTRANSUHRE, VVETRANSDAT, VVETRANSUHR, VVETRANSBEN, VVAKTKZ, VVPSTKKZ, VVANZVP, VVWAEHRSL, VVHWAEHRSL, VVHEUROKURS, VVHEUROKURSVK, VVFEUROKURS, VVFEUROKURSVK, VVLOHNKD, VVARCHKZ, VVARCHDAT, VVARCHBEL, VVSEQUNO, VVLFDPN, VVARTGRP, VVAETINEU, VVPTARIF, VVANSPRECH, VVANSPZUS, VVTRANSSEQ, VVEDI, VVEDIDAT, VVQUITTAIO, VVGESMTR, VVLOAD, VVFILLER, VVAENDZL, VVAENDBEN, VVAENDDAT, VVNEUBEN, VVNEUDAT)"
                                + " VALUES (:VVMANDANT, :VVLIEFSCH, '01', 'M', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'U', 'I', 'EN', '   ', '   ', '   ', '   ', '   ', '   ', 0, ' ', 'CN ', '            ', '·eé?                                    ', '  ', '             ', '    ', '    ', '00000000', '0000', '   ', ' ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', ' ', 0, 0, 0, '   ', '    ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000000000', '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '        ', '        ', ' ', '    ', 0, '    ', 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, '          ', 0, 0, '   ', 0, '   ', 0, 0, ' ', ' ', ' ', '   ', 'N', '                                        ', '                                        ', '                                        ', '                                        ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', '00000000', '01      ', '00000000', ' ', '        ', '        ', '        ', '        ', '    ', '00000000', '        ', '    ', '        ', '        ', '    ', 0, 'N', 'N', 'N', 'N', 'N', 'N', 'N', ' ', '001', 0, 1, 0, 1, 0, '0000000000', '   ', ' ', '    ', 0, '   ', '        ', 0, 0, '        ', '0000000000', 0, 30, '  ', '000000', '000', 0, 0, 0, '        ', '          ', '0000', 0, 0, ' ', ' ', '   ', ' ', ' ', '0000000000', '0000000000', '   ', '  ', 0, 0, ' ', 0, 0, '        ', '        ', ' ', 0, 0, '        ', ' ', 0, 0, ' ', 0, 0, 0, 0, '        ', ' ', ' ', 0, '   ', '   ', 0, ' ', 0, ' ', '        ', ' ', '00000000', '00000000', '000000000000000', '0000', '   ', ' ', ' ', '        ', '                          ', '00000000', ' ', '00000000', ' ', '000000000', '0000', '                                                             ', 1, '        ', 0, 'SUNLV   ', 20120530)";
                    break;
                case "50.25":
                    or1.CommandText = "INSERT INTO VVLIEF(VVMANDANT, VVLIEFSCH, VVLO, VVPRODST1, VVPRODST2, VVPRODST3, VVPRODST4, VVPRODST5, VVPRODST6, VVPRODST7, VVPRODST8, VVPRODST9, VVLIEFSCHTYP, VVKZINLEXP, VVSTATUS, VVVERSART, VVSPED, VVVERSARTU, VVSPEDU, VVVERSARTV, VVSPEDV, VVEBDAT, VVKZEBBUCH, VVLAND, VVPLZ, VVORT, VVBZ, VVBZBEZ, VVCOUNTY, VVCITY, VVAVISNR, VVFBR, VVLIEFBED, VVKZKOSTBER, VVLANDU, VVPLZU, VVORTU, VVBZU, VVBZBEZU, VVCOUNTYU, VVCITYU, VVLIEFSCHGRP, VVVERSDAT, VVLIEFDAT, VVFIXDAT, VVVERPART, VVGUETERNR, VVKZEINZEL, VVEINZTARA, VVEINZBRUT, VVEINZNET, VVANZ, VVTARA, VVBRUTTO, VVNETTO, VVVOLUMEN, VVANZSTK, VVNETMTR, VVWERT, VVLB1, VVANZPAL1, VVANZAPAL1, VVANZRPAL1, VVLB2, VVANZPAL2, VVANZAPAL2, VVANZRPAL2, VVLB3, VVANZPAL3, VVANZAPAL3, VVANZRPAL3, VVLB4, VVANZPAL4, VVANZAPAL4, VVANZRPAL4, VVLB5, VVANZPAL5, VVANZAPAL5, VVANZRPAL5, VVLB6, VVANZPAL6, VVANZAPAL6, VVANZRPAL6, VVKOLP, VVVPLP, VVTPSTA, VVTPMA1, VVTPMAANZ1, VVTPMA2, VVTPMAANZ2, VVGTBS, VVGTBK, VVKM1, VVGTBZ, VVKM2, VVTARIF1, VVORTKL1, VVFRPFL1, VVLAKL1, VVFRSATZ1, VVFRERRECH1, VVMARGEP1, VVMARGEA1, VVSUMME1, VVTARIF2, VVORTKL2, VVFRPFL2, VVLAKL2, VVFRSATZ2, VVFRERRECH2, VVMARGEP2, VVMARGEA2, VVSUMME2, VVTARIF3, VVORTKL3, VVFRPFL3, VVLAKL3, VVFRSATZ3, VVFRERRECH3, VVMARGEP3, VVMARGEA3, VVSUMME3, VVPRAEMIEV, VVPOLICE, VVGDATBIS, VVWERTV, VVWAEHRSLV, VVNEBENKO, VVWAEHRSLN, VVNACHNA, VVFESTBETR, VVVERZOLLT, VVKZABRFR, VVZAHLART, VVZAHLBED, VVKZLSPERR, VVANAME1, VVANAME2, VVASTRASSE, VVASTRASSE2, VVALAND, VVAPLZ, VVAORT, VVABZ, VVABZBEZ, VVACOUNTY, VVACITY, VVKUNDNRV, VVADRSLV, VVKUNDNRE, VVEMPFKZ, VVADRSLL, VVADRSLO, VVKUNDNRVF, VVADRSLKVF, VVADRSLLVF, VVKUNDNRR, VVADRSLKR, VVADRSLLR, VVKUNDNRF, VVADRSLKF, VVADRSLLF, VVANTEILF, VVPI, VVET, VVLS, VVPA, VVLA, VVFR, VVAV, VVDECKBLATT, VVLIEFSCHPOS, VVLPACKNR, VVANZTLIEF, VVANZTLIEFR, VVANZTLIEFB, VVLIEFTERM, VVFRACHTBE, VVVB, VVKZKUNDV, VVZONE, VVKGBIS, VVKDVKL, VVADRSLLUR, VVVALUTA, VVVALDAT, VVEKON, VVVERSIBE, VVVSTK, VVLSTKPA, VVPAUFKRS, VVPAUFLFD, VVPAUFPOS, VVVERPKOST, VVKOSTBGR, VVVERPKOSTE, VVLIEFNR, VVRENR, VVREPOS, VVREDAT, VVFRNETTO, VVFRKSTA, VVZOLLPAP, VVPROGRP, VVUEBKZ, VVDROFT, VVKREDLIM, VVSWING, VVRAITING, VVVERS, VVKREDBIS, VVKREDVON, VVLUEBKZ, VVFRDAT, VVFRZEIT, VVFRBENID, VVKUNDNRRE, VVLIEFART, VVKTRANSDAT, VVKTRANSUHR, VVKTRANSBEN, VVKTRANSSTA, VVSTRANSDATA, VVSTRANSUHRA, VVSTRANSERL, VVSTRANSDATE, VVSTRANSUHRE, VVETRANSDAT, VVETRANSUHR, VVETRANSBEN, VVAKTKZ, VVPSTKKZ, VVANZVP, VVWAEHRSL, VVHWAEHRSL, VVHEUROKURS, VVHEUROKURSVK, VVFEUROKURS, VVFEUROKURSVK, VVLOHNKD, VVARCHKZ, VVARCHDAT, VVARCHBEL, VVSEQUNO, VVLFDPN, VVARTGRP, VVAETINEU, VVPTARIF, VVANSPRECH, VVANSPZUS, VVTRANSSEQ, VVEDI, VVEDIDAT, VVQUITTAIO, VVGESMTR, VVLOAD, VVFILLER, VVAENDZL, VVAENDBEN, VVAENDDAT, VVNEUBEN, VVNEUDAT)"
                        + " VALUES (:VVMANDANT, :VVLIEFSCH, '  ', 'M', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'V', 'E', '  ', '   ', '   ', '   ', '   ', '   ', '   ', 0, ' ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', '00000000', '0000', '   ', 'N', '   ', '            ', '                                        ', '1 ', '             ', '    ', '    ', ' ', 0, 0, 0, '   ', '    ', 'N', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '0000000000', '  ', 1, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '  ', 0, 0, 0, '        ', '        ', ' ', '    ', 0, '    ', 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, '        ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, '          ', 0, 0, '   ', 0, '   ', 0, 0, 'N', 'N', 'N', '   ', 'N', '                                        ', '                                        ', '                                        ', '                                        ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', '00000000', '01      ', '00000000', ' ', '        ', '        ', '        ', '        ', '    ', '00000000', '        ', '    ', '        ', '        ', '    ', 0, 'N', 'N', 'N', 'N', 'N', 'N', 'N', ' ', '001', 1, 1, 0, 0, 0, '0000000000', '   ', 'N', '    ', 0, '   ', '        ', 0, 0, '        ', '0000000000', 0, 0, '  ', '000000', '000', 0, 0, 0, '00000000', '          ', '0000', 0, 0, 'A', 'J', '   ', ' ', ' ', '0000000000', '0000000000', '003', '01', 0, 0, 'N', 0, 0, '        ', '        ', ' ', 0, 0, '        ', ' ', 0, 0, ' ', 0, 0, 0, 0, '        ', ' ', ' ', 0, '   ', '   ', 0, ' ', 0, ' ', '00000000', ' ', '00000000', '00000000', '000000000000000', '0000', '   ', ' ', ' ', '        ', '                          ', '00000000', ' ', '00000000', ' ', '000000000', '0000', '                                                             ', 0, '        ', 0, '        ', 0)";
                    break;
                default:
                    break;
            }
            or1.Parameters.Add("VVMANDANT", OracleType.NVarChar).Value = dwData["VVMANDANT"].ToString();
            or1.Parameters.Add("VVLIEFSCH", OracleType.NVarChar).Value = dwData["VVLIEFSCH"].ToString();
            Connect2Proxy(or1);
        }
        public void InsertVVTLIEF(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    or1.CommandText = "INSERT INTO VVTLIEF(VVTMANDANT, VVTAUFTYP, VVTAUFKRS, VVTAUFLFD, VVTAUFPOS, VVTTEILNR, VVTLOVON, VVTLOAN, VVTTEILNRAN, VVTABHAENGIG, VVTLOABH1, VVTLOABH2, VVTPRODST, VVTKZINLEXP, VVTLAND, VVTPLZ, VVTKUNDNRL, VVTADRSLL, VVTLIEFSCH, VVTLIEFSCHPOS, VVTKUNDNRR, VVTADRSLR, VVTRENR, VVTPFRENR, VVTME, VVTANZSTK, VVTMTR, VVTKG, VVTQM, VVTRUECKANZSTK, VVTRUECKMTR, VVTRUECKKG, VVTRUECKQM, VVTANZVP, VVTLB1, VVTLB2, VVTLB3, VVTLB4, VVTLB5, VVTLB6, VVTZAHLBED, VVTVALUTA, VVTVALDAT, VVTEKON, VVTLIEFBED, VVTLANDU, VVTPLZU, VVTORTU, VVTBZU, VVTBZBEZU, VVTCOUNTYU, VVTCITYU, VVTVERSART, VVTVERPART, VVTLIEFSCHGRP, VVTSTKPA, VVTSPED, VVTPRKZ, VVTDRKZ, VVTDRDAT, VVTAFOLGEV, VVTVB, VVTORT, VVTBZ, VVTBZBEZ, VVTCOUNTY, VVTCITY, VVTREGRP, VVTKDVKL, VVTANAME1, VVTANAME2, VVTASTRASSE1, VVTASTRASSE2, VVTALAND, VVTAPLZ, VVTAORT, VVTABZ, VVTABZBEZ, VVTACOUNTY, VVTACITY, VVTKZVVERP, VVTPRIO, VVTKUNDLO, VVTKUNDLB, VVTKUNDLP, VVTKDBEZKZ, VVTREPOS, VVTVERS, VVTPARTIE, VVTPARTIEKZ, VVTRESTKZ, VVTFORT, VVTKDAUFTNR, VVTKDAUFDAT, VVTPOSTYP, VVTKUNDNR, VVTWERK, VVTABT, VVTWAKZ, VVTART, VVTVAR, VVTFARBE, VVTDESS, VVTCOL, VVTBESCH, VVTGROE, VVTAUFM, VVTSETKZ, VVTLOHNKD, VVTKOLL, VVTSANZSTK, VVTROHMTR, VVTBRUTTO, VVTNETTO, VVTVERDERB, VVTFOLGEMTR, VVTSOLLTEIL, VVTGEBNR, VVTPROGRP, VVTPLFDAT, VVTFBENID, VVTFDAT, VVTFZEIT, VVTVBDAT, VVTLIEFTERM, VVTEILAUS, VVTFRNETTO, VVTHUELTYP, VVTHUELGEW, VVTSPULEN, VVTNETKG, VVTFEUCHTEI, VVTFEUCHTES, VVTHGEWABZ, VVTANZPA, VVTTARA, VVTBRTGEW, VVTPACKTYP, VVTKREDLIM, VVTSWING, VVTRAITING, VVTVERSICH1, VVTVERSICH2, VVTVERSICH3, VVTVERSICH4, VVTVERSICH5, VVTVERSICH21, VVTVERSICH22, VVTVERSICH23, VVTVERSICH24, VVTVERSICH25, VVTKREDBIS, VVTKREDVON, VVTLUEBKZ, VVTFKNVS, VVTFKSPTD, VVTFKSPRD, VVTROHGEW, VVTFERGEW, VVTZUSTAND, VVTARTGRP, VVTARTABW, VVTAPOS, VVTAUFMSL, VVTZENSUR, VVTPOSEXT, VVTKZZUTEI, VVTAKKREDNR, VVTFILLER1)"
                        + " VALUES (:VVTMANDANT, 'K', :VVTAUFKRS, :VVTAUFLFD, :VVTAUFPOS, '0001', '01', '  ', 0, 0, '  ', '  ', 'G', 'E', 'CN ', '            ', '00000200', '        ', :VVTLIEFSCH, :VVTLIEFSCHPOS, '00000200', '        ', '00000000', '00000000', 'KG ', 0, 0, '0000450000', '0000000000', 0, 0, '0000000000', '0000000000', 0, 'YN', '  ', '  ', '  ', '  ', '  ', 'STD', 0, 0, '        ', 'EXW', 'CN ', '42115       ', 'Jiangyin                                ', '1 ', 'Jiangyin     ', '    ', '    ', 'INT', '   ', ' ', 30, 'LKW', '  ', ' ', 0, 0, 'RMB', '·eé?                                    ', '  ', '             ', '    ', '    ', ' ', '   ', '                                        ', '                                        ', '                                        ', '                                        ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', 'N', '9', '  ', '  ', '        ', ' ', '000', ' ', '       ', ' ', ' ', 0, '                    ', 0, '   ', '        ', '   ', '   ', 'V', '19009.30.3              ', '   ', '1M0300    ', '          ', '          ', '          ', '       ', '  ', ' ', '        ', 'JMK10', 0, 0, 0, 0, 0, 0, 0, '        ', '   ', 20110206, 'SUNLV   ', 20120825, 1555, 20110206, 20110206, ' ', 0, '      ', 0, 0, '0000450000', 1825, 1825, 'J', 0, 0, 0, '    ', '0090000000', '0089728588', '003', '01', '  ', '  ', '  ', '  ', '  ', '  ', '  ', '  ', '  ', 20231212, 0, ' ', ' ', 0, 0, 0, 0, '    ', '   ', ' ', '0000', '  ', '  ', '000000', ' ', '                    ', '                                                     ')";
                        break; 
                default:
                    break;
            }
            or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
            or1.Parameters.Add("VVTLIEFSCH", OracleType.NVarChar).Value = dwData["VVTLIEFSCH"].ToString();
            or1.Parameters.Add("VVTLIEFSCHPOS", OracleType.NVarChar).Value = dwData["VVTLIEFSCHPOS"].ToString();
            or1.Parameters.Add("VVTAUFKRS", OracleType.NVarChar).Value = dwData["VVTAUFKRS"].ToString();
            or1.Parameters.Add("VVTAUFLFD", OracleType.NVarChar).Value = dwData["VVTAUFLFD"].ToString();
            or1.Parameters.Add("VVTAUFPOS", OracleType.NVarChar).Value = dwData["VVTAUFPOS"].ToString(); 

             Connect2Proxy(or1);
        }
        #endregion
        
        public void InsertSDDAT(DataRow dwData,string ITXDBVERSION="50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO SDDAT(SDSA,SDKEY,SDDATEN)"
                + "VALUES (:SDSA,:SDKEY, :SDDATEN)";
            or1.Parameters.Add("SDSA", OracleType.NVarChar).Value = dwData["SDSA"];
            or1.Parameters.Add("SDKEY", OracleType.NVarChar).Value = dwData["SDKEY"];
            or1.Parameters.Add("SDDATEN", OracleType.NVarChar).Value = dwData["SDDATEN"];
            Connect2Proxy(or1);
        }
        public void InserAPZUORD(DataRow dwData,string ITXDBVERSION="50.24")
        {
            //APZMANDANT APZART APZVAR APZANRKRS APZALFDNR APZSTUFE
            OracleCommand or1;

            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO APZUORD(APZMANDANT, APZKUNDNR, APZWERK, APZABT, APZART, APZVAR, APZANRKRS, APZALFDNR, APZSTUFE, APZSPEZIF, APZSPSTA, APZSPGRD, APZSTDKALK, APZZUSTAND, APZZUSATZ1, APZZUSATZKZ1, APZZUSATZ2, APZZUSATZKZ2, APZZUSATZ3, APZZUSATZKZ3, APZZUSATZ4, APZZUSATZKZ4, APZZUSATZ5, APZZUSATZKZ5, APZZUSATZ6, APZZUSATZKZ6, APZZUSATZ7, APZZUSATZKZ7, APZZUSATZ8, APZZUSATZKZ8, APZZUSATZ9, APZZUSATZKZ9, APZZUSATZ10, APZZUSATZKZ10, APZZUSATZ11, APZZUSATZKZ11, APZZUSATZ12, APZZUSATZKZ12, APZZUSATZ13, APZZUSATZKZ13, APZZUSATZ14, APZZUSATZKZ14, APZZUSATZ15, APZZUSATZKZ15, APZZUSATZ16, APZZUSATZKZ16, APZZUSATZ17, APZZUSATZKZ17, APZZUSATZ18, APZZUSATZKZ18, APZZUSATZ19, APZZUSATZKZ19, APZZUSATZ20, APZZUSATZKZ20, APZZUSATZ21, APZZUSATZKZ21, APZZUSATZ22, APZZUSATZKZ22, APZZUSATZ23, APZZUSATZKZ23, APZZUSATZ24, APZZUSATZKZ24, APZZUSATZ25, APZZUSATZKZ25, APZZUSATZ26, APZZUSATZKZ26, APZZUSATZ27, APZZUSATZKZ27, APZZUSATZ28, APZZUSATZKZ28, APZZUSATZ29, APZZUSATZKZ29, APZZUSATZ30, APZZUSATZKZ30, APZZUSATZ31, APZZUSATZKZ31, APZZUSATZ32, APZZUSATZKZ32, APZZUSATZ33, APZZUSATZKZ33, APZZUSATZ34, APZZUSATZKZ34, APZZUSATZ35, APZZUSATZKZ35, APZZUSATZ36, APZZUSATZKZ36, APZZUSATZ37, APZZUSATZKZ37, APZZUSATZ38, APZZUSATZKZ38, APZZUSATZ39, APZZUSATZKZ39, APZZUSATZ40, APZZUSATZKZ40, APZZUSATZ41, APZZUSATZKZ41, APZZUSATZ42, APZZUSATZKZ42, APZZUSATZ43, APZZUSATZKZ43, APZZUSATZ44, APZZUSATZKZ44, APZZUSATZ45, APZZUSATZKZ45, APZZUSATZ46, APZZUSATZKZ46, APZZUSATZ47, APZZUSATZKZ47, APZZUSATZ48, APZZUSATZKZ48, APZZUSATZ49, APZZUSATZKZ49, APZZUSATZ50, APZZUSATZKZ50, APZZANRKRS1, APZZALFDNR1, APZZAKZ1, APZZANRKRS2, APZZALFDNR2, APZZAKZ2, APZZANRKRS3, APZZALFDNR3, APZZAKZ3, APZZANRKRS4, APZZALFDNR4, APZZAKZ4, APZPRIO, APZAENDZL, APZAENDBEN, APZAENDDAT, APZNEUBEN, APZNEUDAT, APZFILLER)"
                + "VALUES (:APZMANDANT, '00000000', '   ', '   ', :APZART, :APZVAR, :APZANRKRS, :APZALFDNR, :APZSTUFE, '                                                  ', 'N', '                              ', 'N', '    ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '          ', '  ', '  ', '000000', ' ', '  ', '000000', ' ', '  ', '000000', ' ', '  ', '000000', ' ', '0', 0, '        ', 0, 'NILL    ', '20120811', '                                                 ')";
            or1.Parameters.Add("APZMANDANT", OracleType.NVarChar).Value = dwData["APZMANDANT"].ToString();
            or1.Parameters.Add("APZART", OracleType.NVarChar).Value = dwData["APZART"].ToString();
            or1.Parameters.Add("APZVAR", OracleType.NVarChar).Value = dwData["APZVAR"].ToString();
            or1.Parameters.Add("APZANRKRS", OracleType.NVarChar).Value = dwData["APZANRKRS"].ToString();
            or1.Parameters.Add("APZALFDNR", OracleType.NVarChar).Value = dwData["APZALFDNR"].ToString();
            or1.Parameters.Add("APZSTUFE", OracleType.NVarChar).Value = dwData["APZSTUFE"].ToString();
            setResult = Connect2Proxy(or1);
        }
        public void InsertGSCOLOR(DataRow dwData,string ITXDBVERSION="50.24")
        {
            //GSCMANDANT  GSCART GSCVAR GSCFARBE
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = " INSERT INTO GSCOLOR(GSCMANDANT, GSCART, GSCVAR, GSCFARBE, GSCAENDZL, GSCAENDBEN, GSCAENDDAT, GSCNEUBEN, GSCNEUDAT, GSCSTATUS, GSCSFKZ, GSCBEZ, GSCFKARTNR, GSCKTFARBE, GSCBOM, GSCBOMCGRP, GSCFDVF, GSCVORB, GSCNACHB, GSCFA, GSCRUESTGRP, GSCPRUEFGRP, GSCSTATVF, GSCKZDUMCOL, GSCPSEUDOCOL, GSCTEXTSCHL, GSCMUFRB, GSCSCHLIAUF, GSCFIXTEMP, GSCFIXTIME, GSCABRASION, GSCABRAMTR, GSCPROGRP, GSCARTGRP, GSCRECHNUM, GSCRECHNR, GSCPRGRP, GSCPREIS, GSCZUAK, GSCZUPROZ, GSCANFART, GSCWERT, GSCWERTPROZ, GSCZUAB, GSCZUABPROZ, GSCZTWAHL, GSCVERLUST, GSCKALKMG, GSCLOAN, GSCLBAN, GSCLPAN, GSCPKL, GSCMU, GSCMURLOD, GSCMUPROD, GSCMUCTOD, GSCMUBIRL, GSCMUDTRL, GSCCOLPT1, GSCCOLPT2, GSCCOLPT3, GSCCOLPT4, GSCFILLER)"
                + "VALUES (:GSCMANDANT, :GSCART, :GSCVAR,:GSCFARBE, 0, '        ', 0, 'INTEXE  ', 20120921, 'A', 'N', '                    ', '          ', '          ', ' ', ' ', '   ', '   ', '   ', 0, '   ', ' ', '   ', ' ', '          ', '          ', '          ', 0, 0, 0, 0, 0, '   ', '   ', '    ', 0, ' ', 0, 0, ' ', '    ', 0, ' ', 0, ' ', 0, 0, 0, '  ', '  ', '        ', '  ', ' ', '00', '00', ' ', '        ', 0, ' ', ' ', ' ', ' ', '                                                    ')";
            or1.Parameters.Add("GSCMANDANT", OracleType.NVarChar).Value = dwData["GSCMANDANT"].ToString();
            or1.Parameters.Add("GSCART", OracleType.NVarChar).Value = dwData["GSCART"].ToString();
            or1.Parameters.Add("GSCVAR", OracleType.NVarChar).Value = dwData["GSCVAR"].ToString();
            or1.Parameters.Add("GSCFARBE", OracleType.NVarChar).Value = dwData["GSCFARBE"].ToString();
            setResult = Connect2Proxy(or1);
        }
    }
}
